Re: Issues with Quorum Commit - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Issues with Quorum Commit
Date
Msg-id 4CAE07E5.6090403@agliodbs.com
Whole thread Raw
In response to Re: Issues with Quorum Commit  (Aidan Van Dyk <aidan@highrise.ca>)
List pgsql-hackers
> If you want "synchronous replication" because you want "query
> availabilty" while making sure you're not getting "stale" queries from
> all your slaves, than using your k < N (k = 3 and N - 10) situation is
> screwing your self.

Correct. If that is your reason for synch standby, then you should be
using k = N configuration.

However, some people are willing to sacrifice consistency for durability
and availability.  We should give them that option (eventually), since
among that triad you can never have more than two.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: standby registration (was: is sync rep stalled?)
Next
From: Markus Wanner
Date:
Subject: Re: Issues with Quorum Commit