Re: Help tuning postgres - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Help tuning postgres
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD595@Herge.rcsinc.local
Whole thread Raw
In response to Help tuning postgres  (Csaba Nagy <nagy@ecircle-ag.com>)
List 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


pgsql-performance by date:

Previous
From: Emil Briggs
Date:
Subject: Re: Help tuning postgres
Next
From: Matthew Nuzum
Date:
Subject: Re: Help tuning postgres