determine snapshot after obtaining locks for first statement

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема determine snapshot after obtaining locks for first statement
Дата
Msg-id 4B290861020000250002D644@gw.wicourts.gov
обсуждение исходный текст
Ответы Re: determine snapshot after obtaining locks for first statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
The Cahill thesis mentions an interesting optimization -- they defer
determination of the snapshot until after any locks required for the
first statement have been acquired.  Where the first statement was,
for example, an UPDATE, this reduced re-reads or rollbacks in the
face of concurrent modifications.
Does PostgreSQL currently do this?  If not, would it make sense?
-Kevin


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

Предыдущее
От: Scott Bailey
Дата:
Сообщение: Re: Range types
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Largeobject Access Controls and pg_migrator