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 you
> haven'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.