Re: PostgreSQL as a local in-memory cache - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: PostgreSQL as a local in-memory cache
Date
Msg-id 201006291332.o5TDWTZ01574@momjian.us
Whole thread Raw
In response to Re: PostgreSQL as a local in-memory cache  (Robert Haas)
Responses Re: PostgreSQL as a local in-memory cache  ("Kevin Grittner")
Re: PostgreSQL as a local in-memory cache  (Robert Haas)
List pgsql-performance
Robert Haas wrote:
> On Mon, Jun 28, 2010 at 5:57 PM, Bruce Momjian <> 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  <>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: pgbench results on a new server
Next
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL as a local in-memory cache