Re: Improvement of procArray.xmin for VACUUM

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improvement of procArray.xmin for VACUUM
Дата
Msg-id 7924.1174844122@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improvement of procArray.xmin for VACUUM  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Improvement of procArray.xmin for VACUUM  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-patches
Gregory Stark <stark@enterprisedb.com> writes:
> Well I think this would be the same infrastructure we would need to do
> the other discussed improvement to address pg_dump's impact. That
> would require us to publish the youngest xmax of the live
> snapshots. Vacuum could deduce that that xid cannot possibly see any
> transactions between the youngest extant xmax and the oldest
> in-progress transaction.

... and do what with the knowledge?  Not remove tuples, because any such
tuples would be part of RECENTLY_DEAD update chains that that xact might
be following now or in the future.

            regards, tom lane

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Load distributed checkpoint V3
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Improvement of procArray.xmin for VACUUM