On Tue, Jun 29, 2010 at 9:32 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Robert Haas wrote:
>> On Mon, Jun 28, 2010 at 5:57 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> >> The patch also documents that synchronous_commit = false has
>> >> potential committed transaction loss from a database crash (as well as
>> >> an OS crash).
>> Is this actually true?
> I asked on IRC and was told it is true, and looking at the C code it
> looks true. What synchronous_commit = false does is to delay writing
> the wal buffers to disk and fsyncing them, not just fsync, which is
> where the commit loss due to db process crash comes from.
Ah, I see. Thanks.
The Enterprise Postgres Company
In response to
pgsql-performance by date
|Next:||From: Bruce Momjian||Date: 2010-06-29 17:19:40|
|Subject: Re: PostgreSQL as a local in-memory cache|
|Previous:||From: Bruce Momjian||Date: 2010-06-29 15:29:18|
|Subject: Re: cpu bound postgresql setup.|