On 18.03.2011 16:52, Kevin Grittner wrote:
Simon Riggs<si...@2ndquadrant.com> wrote:
In PostgreSQL other users cannot observe the commit until an
acknowledgement has been received.
Really? I hadn't picked up on that. That makes for a lot of
complication on crash-and-recovery of a master, but if we can pull
it off, that's really cool. If we do that and MySQL doesn't, we
definitely don't want to use the same terminology they do, which
would imply the same behavior.
To be clear: other users cannot observe the commit until standby
acknowledges it - unless the master crashes while waiting for the
acknowledgment. If that happens, the commit will be visible to everyone
after recovery.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
