Re: synchronous_commit and remote_write - Mailing list pgsql-hackers

From Robert Haas
Subject Re: synchronous_commit and remote_write
Date
Msg-id CA+TgmoaR4bwNu=y6U+WwtvcLxwsQjTcBfBs09ysOxfusE=m=-A@mail.gmail.com
Whole thread Raw
In response to Re: synchronous_commit and remote_write  (Bruce Momjian <bruce@momjian.us>)
Responses Re: synchronous_commit and remote_write
List pgsql-hackers
On Wed, May 9, 2012 at 7:29 AM, Bruce Momjian <bruce@momjian.us> wrote:
> Let me point out that our documentation says nothing about it being
> written to the kernel --- it just says "has received the commit record
> of the transaction to memory."

Maybe remote_receive would be better.  If we're actually writing it
back to the kernel before acknowledging the commit, that seems like an
implementation defect more than anything else, since it does not -
AFAICS - provide any additional, useful guarantee.

Another thing I've been wondering is whether, perhaps, we ought to
keep synchronous_commit tri-valued: on/local/off, and have a separate
GUC for synchronous_replication_mode.  It's a bit arbitrary that "on"
happens to mean remote fsync rather than remote write/receive.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Can pg_trgm handle non-alphanumeric characters?
Next
From: Simon Riggs
Date:
Subject: Re: age(xid) on hot standby