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.
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
+ None of us is going to be here forever. +
In response to
pgsql-performance by date
|Next:||From: Kevin Grittner||Date: 2010-06-29 14:14:13|
|Subject: Re: PostgreSQL as a local in-memory cache|
|Previous:||From: Merlin Moncure||Date: 2010-06-29 13:18:14|
|Subject: Re: pgbench results on a new server|