Re: DRAFT 9.6 release

From: Amit Langote
Subject: Re: DRAFT 9.6 release
Date: ,
Msg-id: 3b861f18-6a5d-1b8b-fd15-536e7a846af4@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 10:25, Josh Berkus wrote:
> On 08/30/2016 06:20 PM, Josh Berkus wrote:
>> On 08/30/2016 06:12 PM, Michael Paquier wrote:
>>
>>> Really? Here are the doc quotes that I guess matter, and I read that
>>> differently than you do:
>>> If any of the current synchronous standbys disconnects for whatever
>>> reason, it will be replaced immediately with the next-highest-priority
>>> standby.
>>> [...]
>>> For example, a setting of 3 (s1, s2, s3, s4) makes transaction commits
>>> wait until their WAL records are received by *three higher-priority
>>> standbys* chosen from standby servers s1, s2, s3 and s4.
>>>
>>> This clearly says that we wait for the servers that have a higher
>>> priority, meaning that we do *not* wait for any k elements in a set of
>>> n listed, but suggest that the order of the element matters.
>>
>> Yeah, the problem is that "higher priority" isn't defined, and could
>> mean a lot of things.  It *is* defined in the actual section on
>> synchronous standby, though (25.2.8.2.); maybe what we need is less docs
>> under the GUC and more references to that?
>>
>> Otherwise, you're going to have lots of people confused that it's
>> actually quorum commit, as witnessed by the current discussion.  Right
>> now what's in the GUC doc page appears to be complete but isn't.
>
> Also, if I do this:
>
>
> 2 ( g1, g2, g3 )
>
> ... and g1, g2 and g3 are *groups* of three standbys each, what happens?
>  Does it wait for one or more responses from g1 and from g2, or does
> getting two responses from g1 trigger a commit?

We do not support specifying groups either.  Names refer to the actual
standby names.  Groups part of the earlier proposal(s) was taken out of
the patch, IIRC.

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