Re: SSI predicate locking on heap -- tuple or row?

Поиск
Список
Период
Сортировка
От Dan Ports
Тема Re: SSI predicate locking on heap -- tuple or row?
Дата
Msg-id 20110602213749.GB10064@csail.mit.edu
обсуждение исходный текст
Ответ на Re: SSI predicate locking on heap -- tuple or row?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: 9.2 branch and 9.1beta2 timing (was Re: InitProcGlobal cleanup)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: 9.2 branch and 9.1beta2 timing (was Re: InitProcGlobal cleanup)