Re: determine snapshot after obtaining locks for first statement

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: determine snapshot after obtaining locks for first statement
Дата
Msg-id 4B29F444020000250002D6AD@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: determine snapshot after obtaining locks for first statement  ("Markus Wanner" <markus@bluegap.ch>)
Ответы Re: determine snapshot after obtaining locks for first statement  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
"Markus Wanner" <markus@bluegap.ch> wrote:
> Another line of thought: isn't this like READ COMMITTED for just
> the first operation in a SERIALIZABLE transaction?
I've mulled it over and I have two different logical proofs that
this is safe; if anyone is dubious I'd be happy to share.
This seems likely to be of significant benefit in some workloads,
and I can't see anywhere that it is likely to cost much.  Any
objections to adding this to the TODO list as a performance item?
-Kevin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Hot Standby and prepared transactions
Следующее
От: Robert Haas
Дата:
Сообщение: Re: determine snapshot after obtaining locks for first statement