Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date
Msg-id 11392.1289956663@sss.pgh.pa.us
Whole thread Raw
In response to Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
I wrote:
> The fsync is associated with the write, which is not done with insert
> lock held.  We're not quite that dumb.

But wait --- are you thinking of the call path where a write (and
possible fsync) is forced during AdvanceXLInsertBuffer because there's
no WAL buffer space left?  If so, that's *exactly* the scenario that
can be expected to be less common with more buffer space.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Next
From: Tom Lane
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?