On Wed, Nov 30, 2011 at 1:37 AM, YAMAMOTO Takashi <y...@mwd.biglobe.ne.jp> 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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers