> On Wed, Nov 30, 2011 at 1:37 AM, YAMAMOTO Takashi
> <yamt(at)mwd(dot)biglobe(dot)ne(dot)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?
simply because it was expensive on my environment.
> thought the point of synchronous_commit=off was to move the fsyncs to
> the background, but not necessarily to decrease the frequency.
it makes sense.
but it's normal for users to abuse features. :)
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2011-12-01 07:16:00|
|Subject: Re: Large number of open(2) calls with bulk INSERT into
|Previous:||From: Greg Smith||Date: 2011-12-01 05:47:40|
|Subject: Re: Word-smithing doc changes|