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