Re: Sync Rep v19

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Sync Rep v19
Date: 2011-03-05 13:05:31
Message-ID: AANLkTi=AuKLJCSD7TcTHiO-JqseR1ybJM4KZ8H_LNFxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Mar 5, 2011 at 7:49 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Sat, 2011-03-05 at 07:24 -0500, Robert Haas wrote:
>> On Sat, Mar 5, 2011 at 6:04 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> > It is documented that the selection of standby from a set of similar
>> > priorities is indeterminate. Users don't like it, they can change it.
>>
>> That doesn't seem like a good argument to *change* the synchronous
>> standby once it's already set.
>
> If the order is arbitrary, why does it matter if it changes?
>
> The user has the power to specify a sequence, yet they have not done so.
> They are told the results are indeterminate, which is accurate. I can
> add the words "and may change as new standbys connect" if that helps.

I just don't think that's very useful behavior. Suppose I have a
master and two standbys. Both are local (or both are remote with
equally good connectivity). When one of the standbys goes down, there
will be a hiccup (i.e. transactions will block trying to commit) until
that guy falls off and the other one takes over. Now, when he comes
back up again, I don't want the synchronous standby to change again;
that seems like a recipe for another hiccup. I think "who the current
synchronous standby is" should act as a tiebreak.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-03-05 13:41:57 Re: Alpha4 release blockers (was Re: wrapping up this CommitFest)
Previous Message Simon Riggs 2011-03-05 12:49:46 Re: Sync Rep v19