Re: BUG #13002: VACUUM to prevent wraparound blocks TRUNCATE

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #13002: VACUUM to prevent wraparound blocks TRUNCATE
Дата
Msg-id 20150408194547.GW4369@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: BUG #13002: VACUUM to prevent wraparound blocks TRUNCATE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
David G. Johnston wrote:

> ​Related question: does a truncated table effectively reset its wraparound
> counter back to zero?

Yes, the relfrozenxid is set to RecentXmin (see ExecuteTruncate).  Not
quite zero age but unless you have really old transactions around,
should be close enough.

> If the table in question is being truncated regularly it doesn't seem like
> this situation should arise.

Correct.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #13002: VACUUM to prevent wraparound blocks TRUNCATE
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #13002: VACUUM to prevent wraparound blocks TRUNCATE