Skip site navigation (1) Skip section navigation (2)

Re: synchronous_commit and remote_write

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Aidan Van Dyk <aidan(at)highrise(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: synchronous_commit and remote_write
Date: 2012-05-09 07:52:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On 9 May 2012 03:52, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Tue, May 08, 2012 at 10:29:31PM -0400, Aidan Van Dyk wrote:
>> On Tue, May 8, 2012 at 10:09 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> >> And then, I could envision (if it continues down this road):
>> >>   off
>> >>   local
>> >>   remote_accept
>> >>   remote_write
>> >>   remote_sync
>> >>   remote_apply (implies visible to new connections on the standby)
>> >>
>> >> Not saying all off these are necessarily worth it, but they are all
>> >> the various "stages" of WAL processing on the remote...
>> >
>> > The _big_ problem with "write" is that we might need that someday to
>> > indicate some other kind of write, e.g. write to kernel, fsync to disk.
>> Well, yes, but in the sequence of:
>> >>   remote_accept
>> >>   remote_write
>> >>   remote_sync
>> it is much more clear...
>> With a single "remote_write", you can't tell just by itself it that is
>> intended to  be "it's a write *to* the remote", or "it's a write *by*
>> the remote".  But when combined with other terms, only one makes sense
>> in all cases.
> Yep.  In fact, remote_write I thought meant a remote write, while it
> currently means a write to the remote.  I like remote_accept.

The naming is not arbitrary. -1 to changing it as suggested.

It is as Aidan says, a state between receive and fsync, normally
referred to as write.

Plus the word remote denotes it is on the standby, not the local master.

So both words have specific meaning, and IMHO clear meaning.

 Simon Riggs         
 PostgreSQL Development, 24x7 Support, Training & Services

In response to


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2012-05-09 11:29:12
Subject: Re: synchronous_commit and remote_write
Previous:From: Albe LaurenzDate: 2012-05-09 07:27:23
Subject: Re: problem/bug in drop tablespace?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group