Re: VACUUM and transaction ID wraparound

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: VACUUM and transaction ID wraparound
Дата
Msg-id Pine.LNX.4.33.0305220848490.23585-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: VACUUM and transaction ID wraparound  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-general
On Wed, 21 May 2003, Andrew Sullivan wrote:

> 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.

I'm not sure if it's vacuum full or vacuum, but I do know you have to
vacuum ALL the tables in ALL your databases to prevent wrap around.

Full or not, I'm not really sure.  But I run fulls every night anyway.



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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: caching query results
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: SELECT DISTINCT ON bug?