On Wed, Jun 16, 2010 at 12:00 PM, Josh Berkus <j...@agliodbs.com> wrote: > >> * fsync=off => 5,100 >> * fsync=off and synchronous_commit=off => 5,500 > > Now, this *is* interesting ... why should synch_commit make a difference > if fsync is off? > > Anyone have any ideas? >
I may have stumbled upon this by my ignorance, but I thought I read that synchronous_commit controlled whether it tries to line up commits or has a more free-for-all that may cause some intermediate weirdness. -- Jonathan Gardner jgard...@jonathangardner.net -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
