Re: [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'. - Mailing list pgsql-hackers

From Thom Brown
Subject Re: [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.
Date
Msg-id CAA-aLv7NV-bAJ-u_knsg9BU16M=98WtCtU3ytdzzQd8Esb5s1w@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.
List pgsql-hackers
On 16 April 2012 17:21, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Sun, Apr 15, 2012 at 12:13 AM, Thom Brown <thom@linux.com> wrote:
>> No, that's not what I was referring to.  If you don't have a standby
>> (i.e. a single, isolated database cluster with no replication), and
>> its synchronous_commit is set to 'remote_write', what effect does that
>> have?
>
> It's the same effect as 'on' and 'local' do, i.e., transaction commit waits
> for only local WAL flush. This behavior is not documented explicitly...
> How should we change the document? What about adding the following
> into the explanation of synchronous_commit parameter (maybe the end
> of second paragraph of that)?
>
> -----------------
> If synchronous_standby_names is not set, on, remote_write and local
> provide the same synchronization level; transaction commit only waits for
> local flush.
> -----------------

Yes, that sounds fine.

--
Thom


pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments
Next
From: Atri Sharma
Date:
Subject: Re: [JDBC] Regarding GSoc Application