Re: Quorum commit for multiple synchronous replication. - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Quorum commit for multiple synchronous replication.
Date
Msg-id CAHGQGwEMgEcVb8tjp07HD6cvL8Wn38BNufavYDdM+saY1R6p6Q@mail.gmail.com
Whole thread Raw
In response to Re: Quorum commit for multiple synchronous replication.  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: Quorum commit for multiple synchronous replication.  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Sat, Aug 6, 2016 at 6:36 PM, Petr Jelinek <petr@2ndquadrant.com> wrote:
> On 04/08/16 06:40, Masahiko Sawada wrote:
>>
>> On Wed, Aug 3, 2016 at 3:05 PM, Michael Paquier
>> <michael.paquier@gmail.com> wrote:
>>>
>>> On Wed, Aug 3, 2016 at 2:52 PM, Masahiko Sawada <sawada.mshk@gmail.com>
>>> wrote:
>>>>
>>>> I was thinking that the syntax for quorum method would use '[ ... ]'
>>>> but it will be confused with '( ... )' priority method used.
>>>> 001 patch adds 'Any N ( ... )' style syntax but I know that we still
>>>> might need to discuss about better syntax, discussion is very welcome.
>>>> Attached draft patch, please give me feedback.
>>>
>>>
>>> I am +1 for using either "{}" or "[]" to define a quorum set, and -1
>>> for the addition of a keyword in front of the integer defining for how
>>> many nodes server need to wait for.
>>
>>
>> Thank you for reply.
>> "{}" or "[]" are not bad but because these are not intuitive, I
>> thought that it will be hard for uses to use different method for each
>> purpose.
>>
>
> I think the "any" keyword is more explicit and understandable, also closer
> to SQL. So I would be in favor of doing that.

+1

Also I like the following Simon's idea.

https://www.postgresql.org/message-id/CANP8+jLHfBVv_pW6grASNUpW+bdk5DcTu7GWpNAP-+-ZWvKT6w@mail.gmail.com
-----------------------
* first k (n1, n2, n3) – does the same as k (n1, n2, n3) does now
* any k (n1, n2, n3) – would release waiters as soon as we have the
responses from k out of N standbys. “any k” would be faster, so is
desirable for performance and resilience
-----------------------

Regards,

--
Fujii Masao



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Send numeric version to clients
Next
From: Aleksander Alekseev
Date:
Subject: Re: Missing checks when malloc returns NULL...