Re: Additional options for Sync Replication

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, "Robert Haas" <robertmhaas@gmail.com>
Cc: "Simon Riggs" <simon@2ndquadrant.com>, "pgsql-hackers" <pgsql-hackers@postgresql.org>
Date: 2011-03-28T15:01:47Z
Lists: pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
 
> We also need to consider the issue raised elsewhere - that a naive
> implementation of this could allow the commit to become visible on
> the standby before it becomes visible on the master.  That would
> be expensive to prevent, because you'd need an additional set of
> master-standby interlocks, but I think at least one person was
> arguing that it was necessary for correctness - my memory of the
> details is fuzzy at the moment.
 
I remember expressing concern about that; I don't know if anyone
else did.  After some discussion, I was persuaded that the use cases
where it would matter are narrow enough that documentation of the
issue should be enough.
 
-Kevin