Skip site navigation (1) Skip section navigation (2)

Re: synchronous commit vs. hint bits

From: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi)
To: robertmhaas(at)gmail(dot)com
Cc: simon(at)2ndquadrant(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: synchronous commit vs. hint bits
Date: 2011-12-01 06:29:32
Message-ID: 20111201062932.DF04014A257@mail.netbsd.org (view raw or flat)
Thread:
Lists: pgsql-hackers
hi,

> 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.

> I
> 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. :)

YAMAMOTO Takashi

> 
> -- 
> 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:
> http://www.postgresql.org/mailpref/pgsql-hackers

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2011-12-01 07:16:00
Subject: Re: Large number of open(2) calls with bulk INSERT into empty table
Previous:From: Greg SmithDate: 2011-12-01 05:47:40
Subject: Re: Word-smithing doc changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group