Re: synchronous commit vs. hint bits - Mailing list pgsql-hackers

From Robert Haas
Subject Re: synchronous commit vs. hint bits
Date
Msg-id CA+TgmobxA-b8sZey9wvcFND9P3W2Pub1haatpg5pfRKZ-6sA8w@mail.gmail.com
Whole thread Raw
In response to Re: synchronous commit vs. hint bits  (yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi))
Responses Re: synchronous commit vs. hint bits
Re: synchronous commit vs. hint bits
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Jan Urbański
Date:
Subject: Re: Java LISTEN/NOTIFY client library work-around
Next
From: Robert Haas
Date:
Subject: Re: Word-smithing doc changes