Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
Дата
Msg-id 5224.1255142294@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Michal Szymanski wrote:
>> In old version of Postgres we have to execute 'VACUUM FULL' to solve
>> problem of  transaction ID wraparound, do we need to execute 'VACUUM
>> FULL' in Postgres 8.3 or 8.4 to avoid this problem?

> No, plain VACUUM suffices.

Just to clarify: plain VACUUM has always sufficed; in *no* version of
Postgres has it ever been the case that VACUUM FULL was more useful
than VACUUM to protect against wraparound.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Regexp confusion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Regexp confusion