Re: Postgres on RAID5

Alex Turner wrote:
> 35 Trans/sec is pretty slow, particularly if they are only one row at
> a time.  I typicaly get 200-400/sec on our DB server on a bad day.  Up
> to 1100 on a fresh database.

Well, don't rule out that his raid controller is not caching his writes.
His WAL sync method may be overriding his raid cache policy and flushing
his writes to disk, always.  Win32 has the same problem, and before
Magnus's O_DIRECT patch, there was no way to easily work around it
without turning fsync off.  I'd suggest playing with different WAL sync
methods before trying anything else.

Merli