Re: Minimally avoiding Transaction Wraparound in VLDBs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Minimally avoiding Transaction Wraparound in VLDBs
Дата
Msg-id 12257.1125581735@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Minimally avoiding Transaction Wraparound in VLDBs  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> So, will per-table XID tracking allow us to avoid *ever* vacuuming some  
> tables?

If your definition of "ever" is less than a billion transactions, sure.
(As Simon points out, with time-partitioned data sets that could often
be arranged, so it's not a completely silly response.)

> If not, what could?

The only possibility for more-than-a-billion is widening XIDs to 64
bits, which would come with its own set of performance penalties.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Minimally avoiding Transaction Wraparound in VLDBs
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Remove xmin and cmin from frozen tuples