On Wed, Nov 30, 2011 at 1:37 AM, YAMAMOTO Takashi
<yamt@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