Re: standby registration (was: is sync rep stalled?) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: standby registration (was: is sync rep stalled?)
Date
Msg-id AANLkTi=f7xvzKrDrPVb6PAGXLPweQY==rHVNk_1sZnAv@mail.gmail.com
Whole thread Raw
Responses Re: standby registration (was: is sync rep stalled?)
List pgsql-hackers
On Mon, Oct 4, 2010 at 3:08 AM, Markus Wanner <markus@bluegap.ch> wrote:
> On 10/01/2010 05:06 PM, Dimitri Fontaine wrote:
>> Wait forever can be done without standby registration, with quorum commit.
>
> Yeah, I also think the only reason for standby registration is ease of
> configuration (if at all). There's no technical requirement for standby
> registration, AFAICS. Or does anybody know of a realistic use case
> that's possible with standby registration, but not with quorum commit?

Quorum commit, even with configurable vote weights, can't handle a
requirement that a particular commit be replicated to (A || B) && (C
|| D).

The use case is something like "we want to make sure we've replicated
to at least one of the two servers in the Berlin datacenter and at
least one of the two servers in the Hong Kong datacenter".

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


pgsql-hackers by date:

Previous
From: Hakan Kocaman
Date:
Subject: MIT benchmarks pgsql multicore (up to 48)performance
Next
From: Tom Lane
Date:
Subject: Re: OUTER keyword