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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])