Re: SSI predicate locking on heap -- tuple or row? - Mailing list pgsql-hackers

From Dan Ports
Subject Re: SSI predicate locking on heap -- tuple or row?
Date
Msg-id 20110602213749.GB10064@csail.mit.edu
Whole thread Raw
In response to Re: SSI predicate locking on heap -- tuple or row?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Thu, Jun 02, 2011 at 01:01:05PM -0500, Kevin Grittner wrote:
> If we're going to put this into the README-SSI as the proof of the
> validity of this optimization, I'd like to have a footnote pointing
> to a paper describing the "first commit in the cycle" aspect of a
> dangerous structure.  Got any favorites, or should I fall back on a
> google search?

Hmm. I don't see any that state that in so many words, but it's an
obvious consequence of the proof of Theorem 2.1 in "Making Snapshot
Isolation Serializable" -- note that T3 is chosen to be the transaction
in the cycle with the earliest commit time.

Dan

-- 
Dan R. K. Ports              MIT CSAIL                http://drkp.net/


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: 9.2 branch and 9.1beta2 timing (was Re: InitProcGlobal cleanup)
Next
From: Robert Haas
Date:
Subject: Re: 9.2 branch and 9.1beta2 timing (was Re: InitProcGlobal cleanup)