Re: Help tuning postgres

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Csaba Nagy" <nagy(at)ecircle-ag(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help tuning postgres
Date: 2005-10-12 15:54:17
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD595@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The disk used for the data is an external raid array, I don't know
much
> about that right now except I think is some relatively fast IDE stuff.
> In any case the operations should be cache friendly, we don't scan
over
> and over the big tables...

Maybe you are I/O bound. Do you know if your RAID array is caching your
writes? Easy way to check is to run fsync off and look for obvious
performance differences. Maybe playing with sync method could help
here.

Merlin

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Nuzum 2005-10-12 16:39:50 Re: Help tuning postgres
Previous Message Emil Briggs 2005-10-12 15:33:56 Re: Help tuning postgres