Re: VACUUM and transaction ID wraparound

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM and transaction ID wraparound
Дата
Msg-id 17100.1053612677@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: VACUUM and transaction ID wraparound  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: VACUUM and transaction ID wraparound  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Sat, May 17, 2003 at 02:34:19PM +1000, Martijn van Oosterhout wrote:
>> I beleive they are referring to the difference between VACUUM and VACUUM
>> FULL. The former is faster and doesn't lock tables, but the latter is
>> required to solve transaction wraparound.

> It is?  I didn't think VACUUM FULL was ever required.

Either one will get the job done as far as avoiding wraparound goes.
If there's someplace in the docs that seems to you to give a different
impression, please tell me where.

            regards, tom lane

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: "IN" statement causing execution cancel?
Следующее
От: Thomas Beutin
Дата:
Сообщение: Re: compiling mod_auth_pgsql