On Apr 14, 2006, at 8:00 AM, Marc Cousin wrote:
So, you'll probably end up being slowed down by WAL fsyncs ... and you won't have a lot of solutions. Maybe you should start with trying to set fsync=no as a test to confirm that (you should have a lot of iowaits right now if youhaven't disabled fsync).
Instead of doing that, why not use commit_delay to some nominal value to try and group the fsyncs. If they're coming in at 30 per second, this should help a bit, I suspect.
