Re: Additional options for Sync Replication

Robert Haas <robertmhaas(at)gmail(dot)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