Re: DRAFT 9.6 release

From: Amit Langote
Subject: Re: DRAFT 9.6 release
Date: ,
Msg-id: 1f8fa578-5da2-9082-b3b9-81d079171a75@lab.ntt.co.jp
(view: Whole thread, Raw)
In response to: Re: DRAFT 9.6 release  (Josh Berkus)
List: pgsql-advocacy

Tree view

DRAFT 9.6 release  (Josh Berkus, )
 Re: DRAFT 9.6 release  (Amit Langote, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Bruce Momjian, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Bruce Momjian, )
   Re: DRAFT 9.6 release  (Michael Paquier, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Michael Paquier, )
  Re: DRAFT 9.6 release  (Amit Langote, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Amit Langote, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Michael Paquier, )
  Re: DRAFT 9.6 release  (Amit Langote, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Michael Paquier, )
  Re: DRAFT 9.6 release  (Josh Berkus, )
   Re: DRAFT 9.6 release -- is Final  (Josh Berkus, )
    Re: DRAFT 9.6 release -- is Final  (Simon Riggs, )
     Re: DRAFT 9.6 release -- is Final  (Simon Riggs, )
  Re: DRAFT 9.6 release -- is Final  (Josh Berkus, )
   Re: DRAFT 9.6 release -- is Final  (Stefan Kaltenbrunner, )
    Re: DRAFT 9.6 release -- is Final  (Simon Riggs, )
  Re: DRAFT 9.6 release -- is Final  (Josh Berkus, )
  Re: DRAFT 9.6 release -- is Final  (Josh Berkus, )
  Re: DRAFT 9.6 release -- new wording  (Josh Berkus, )
   Re: DRAFT 9.6 release -- new wording  (Justin Clift, )
    Re: DRAFT 9.6 release -- new wording  (Justin Clift, )
    Re: DRAFT 9.6 release -- new wording  (Robert Haas, )
   Re: DRAFT 9.6 release -- new wording  (Mike Toews, )
   Re: DRAFT 9.6 release -- new wording  (Masahiko Sawada, )
   Re: DRAFT 9.6 release -- new wording  (Josh Berkus, )
    Re: [MASSMAIL]Re: DRAFT 9.6 release -- new wording  ("Gilberto Castillo", )
   Re: DRAFT 9.6 release -- new wording  (Josh Berkus, )
    Re: DRAFT 9.6 release -- new wording  (Michael Banck, )
   Re: DRAFT 9.6 release -- new wording  (Josh Berkus, )
   Re: DRAFT 9.6 release -- new wording  (Josh Berkus, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Michael Paquier, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Michael Paquier, )
   Re: DRAFT 9.6 release  (Amit Langote, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  ("Nicholson, Brad (Toronto, ON, CA)", )
   Re: DRAFT 9.6 release  (Michael Paquier, )
  Re: DRAFT 9.6 release  (Robert Haas, )
   Re: DRAFT 9.6 release  (Bruce Momjian, )
    Re: DRAFT 9.6 release  (Robert Haas, )
 Re: DRAFT 9.6 release  (Josh Berkus, )
  Re: DRAFT 9.6 release  (Michael Paquier, )

On 2016/08/31 9:40, Josh Berkus wrote:
> On 08/30/2016 05:35 PM, Michael Paquier wrote:
>> Assuming that all servers are connected at the moment decision is
>> made, you need to wait for s1, s2 *and* s3 to acknowledge depending on
>> synchronous_commit. By default that would be waiting for the LSN to
>> have been flushed on all of them. And the important point to get is
>> that what has been committed is dependent on the order of the items
>> listed. This is not quorum commit, in which case having only
>> confirmation from 3 servers in the set of 5 servers listed would be
>> fine.
>>
>> If for example s2 and s4 are not connected at the moment of the
>> decision, you'd need to wait for acknowledgment from s1, s3 and s5
>> before moving on.
>
> OK, so this says to me that we need a bunch of additional documentation
> on this feature, because the existing docs read like it's "any 3 out of
> the list" instead of "the first 3 which are connected".

IIUC, "any 3 out of the list" will be the quorum logic.  Currently, the
order of listing of standby names determines their priority of being the
next potential synchronous standby if and when we start running short of
3.  So "the first 3 which are connected" is exactly the feature that's
available.  Of course unless I am missing something.

Thanks,
Amit





pgsql-advocacy by date:

From: Michael Paquier
Date:
Subject: Re: DRAFT 9.6 release
From: Josh Berkus
Date:
Subject: Re: DRAFT 9.6 release