Simon Riggs <si...@2ndquadrant.com> wrote: > On Fri, 2011-03-18 at 20:19 +0100, Markus Wanner wrote: >> >>> Simon Riggs<si...@2ndquadrant.com> wrote: >> >>>> In PostgreSQL other users cannot observe the commit until an >> >>>> acknowledgement has been received. >> >> On other nodes as well? To me that means the standby needs to >> hold back COMMIT of an ACKed transaction, until receives a re-ACK >> from the master, that it committed the transaction there. How >> else could the slave know when to commit its ACKed transactions? > > We could do that easily enough, actually, if we wished. > > Do we wish? +1 If we're going out of our way to suppress it on the master until the COMMIT returns, it shouldn't be showing on the replicas before that. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
