On Wed, Jul 13, 2011 at 3:41 PM, lars <lhofha...@yahoo.com> wrote: > On 07/13/2011 11:42 AM, Kevin Grittner wrote: >> >> So transactions without an XID *are* sensitive to >> synchronous_commit. That's likely a useful clue. >> >> How much did it help the run time of the SELECT which followed the >> UPDATE? > > It has surprisingly little impact on the SELECT side:
If your fsync is truly fsyncing, it seems like it should have considerable effect. Could you strace with both -ttt and -T, with and without synchronous commit? Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
