Hi Robert, On Wednesday, November 30, 2011 02:10:00 PM Robert Haas wrote: > On Wed, Nov 30, 2011 at 1:37 AM, YAMAMOTO Takashi > > <[email protected]> wrote: > >> Yes, I would expect that. What kind of increase are you seeing? Is > >> it causing a problem for you, or are you just making an observation? > > > > i was curious because my application uses async commits mainly to > > avoid frequent fsync. i have no numbers right now. > Oh, that's interesting. Why do you want to avoid frequent fsyncs? I > thought the point of synchronous_commit=off was to move the fsyncs to > the background, but not necessarily to decrease the frequency. Is that so? If it wouldn't avoid fsyncs how could you reach multiple thousand TPS in a writing pgbench run on a pretty ordinary system with fsync=on?
Andres -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
