Re: GetCurrentVirtualXIDs()

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: GetCurrentVirtualXIDs()
Дата
Msg-id
22820.1238867053@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
GetCurrentVirtualXIDs() Simon Riggs <simon@2ndQuadrant.com>
Re: GetCurrentVirtualXIDs() Tom Lane <tgl@sss.pgh.pa.us>
Re: GetCurrentVirtualXIDs() Simon Riggs <simon@2ndQuadrant.com>
Re: GetCurrentVirtualXIDs() Tom Lane <tgl@sss.pgh.pa.us>
Re: GetCurrentVirtualXIDs() Simon Riggs <simon@2ndQuadrant.com>
Re: GetCurrentVirtualXIDs() Tom Lane <tgl@sss.pgh.pa.us>
Re: GetCurrentVirtualXIDs() Tom Lane <tgl@sss.pgh.pa.us>
Re: GetCurrentVirtualXIDs() Tom Lane <tgl@sss.pgh.pa.us>
Re: GetCurrentVirtualXIDs() Simon Riggs <simon@2ndQuadrant.com>
Simon Riggs  writes:
> No need to wait for idle-in-transaction sessions during index builds.
> GetCurrentVirtualXIDs() specifically *includes* backends that have
> proc->xmin == InvalidTransactionId (0), but I'm not sure why.

Applied with the discussed tweaks.  I also added some logic to make
DefineIndex recheck the GetCurrentVirtualXIDs output each time it is
about to wait for another session.  If we observe some other session
to have xmin = 0 at any one of those instants, we don't have to
wait for it.  Not sure how much that will really help in practice,
but it can't hurt.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Greg Stark
Дата:
От: Robert Haas
Дата:
FAQ