From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Simon Riggs <simon@2ndQuadrant.com>
Cc: Markus Wanner <markus@bluegap.ch>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: MARK CALLAGHAN <mdcallag@gmail.com>
Cc: Aidan Van Dyk <aidan@highrise.ca>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.
Date: Fri, 18 Mar 2011 11:27:57 -0500
Message-ID: <4D8341BD020000250003BAB2@gw.wicourts.gov> (raw)
In-Reply-To: <4D837EA2.2070205@enterprisedb.com>
References: <E1PwMns-00047O-UU@gemulon.postgresql.org>
<4D741441.2090704@dunslane.net>
<1299454125.1696.6138.camel@ebony>
<4D74896C.5030402@enterprisedb.com>
<4D74DDFA.70800@dunslane.net>
<4D74E584.7080409@enterprisedb.com>
<4D74E9FA.7070202@dunslane.net>
<AANLkTinkzJ=UrLbThZy2KeQg+SjwYqj2r0mDomMwirB7@mail.gmail.com>
<4D74F3AE.9000802@dunslane.net>
<4D74FDEC.5040406@enterprisedb.com>
<4D74FF15.1070804@dunslane.net>
<1299513979-sup-1987@alvh.no-ip.org>
<4D832571.5030808@bluegap.ch>
<AANLkTi=B+cWE-pQJQM=zoA9=Zr25W7zPPMFvvBe11O4E@mail.gmail.com>
<1300457958.18619.13780.camel@ebony>
<4D832B4D020000250003BA98@gw.wicourts.gov>
<4D837EA2.2070205@enterprisedb.com>
> On 18.03.2011 16:52, Kevin Grittner wrote:
>> Simon Riggs<simon@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.
Markus Wanner <markus@bluegap.ch> wrote:
> What complication do you have in mind here?
Basically, what Heikki addresses. It has to be committed after
crash and recovery, and deal with replicas which may or may not have
been notified and may or may not have applied the transaction.
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
> 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.
Right. If other transactions cannot see the transaction before the
COMMIT returns, I was kinda assuming that this was the behavior,
because otherwise one or more replicas could be ahead of the master
after recovery, which would be horribly broken. I agree that the
behavior which you describe is much better than allowing other
transactions to see the work of the pending COMMIT.
In fact, on further reflection, allowing other transactions to see
work before the committing transaction returns could lead to broken
behavior if that viewing transaction took some action based on the
that, the master crashed, recovery was done using a standby, and
that standby hadn't persisted the transaction. So this behavior is
necessary for good behavior. Even though that "perfect storm" of
events might be fairly rare, the difference in the level of
confidence in correctness is significant, and certainly something to
brag about.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, heikki.linnakangas@enterprisedb.com, simon@2ndQuadrant.com, markus@bluegap.ch, alvherre@commandprompt.com, andrew@dunslane.net, mdcallag@gmail.com, aidan@highrise.ca, pgsql-hackers@postgresql.org
Subject: Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.
In-Reply-To: <4D8341BD020000250003BAB2@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox