Simon Riggs <si...@2ndquadrant.com> writes: > I've said COMMIT with no option because I believe that we have only two > choices: commit or wait (perhaps forever), and IMHO waiting is not good. > > We can't ABORT, because we sent a commit to the standby.
Ah yes, I keep forgetting Sync Rep is not about 2PC. Sorry about that. > Waiting might sound attractive. In practice, waiting will make all of > your connections lock up and it will look to users as if their master > has stopped working as well. (It has!). I can't imagine why anyone would > ever want an option to select that; its the opposite of high > availability. Just sounds like a serious footgun. I guess that if there's a timeout GUC it can still be set to infinite somehow. Unclear as the use case might be. Regards, -- dim -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
