Re: synchronous commit vs. hint bits

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: YAMAMOTO Takashi <yamt@mwd.biglobe.ne.jp>

Cc: simon@2ndquadrant.com, pgsql-hackers@postgresql.org

Date: 2011-11-30T13:10:00Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Allow hint bits to be set sooner for temporary and unlogged tables.
- 53f1ca59b587 9.2.0 cited

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