On Wednesday, November 30, 2011 02:10:00 PM Robert Haas wrote:
> 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? 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?
In response to
pgsql-hackers by date
|Next:||From: jesper||Date: 2011-12-01 09:12:53|
|Subject: Re: Accounting for toast in query planner. (gin/gist
|Previous:||From: Magnus Hagander||Date: 2011-12-01 07:50:14|
|Subject: Re: Review of VS 2010 support patches|