Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
Date
Msg-id 20091009233914.GJ5303@alvh.no-ip.org
Whole thread Raw
In response to transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?  (Michal Szymanski <dyrex@poczta.onet.pl>)
Responses Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
List pgsql-general
Tree view 
Michal Szymanski wrote:
> Hi,
> 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.

> How to check using SQL if  transaction ID is close to wraparound?

See age(datfrozenxid) FROM pg_database, but ignore system databases.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Regexp confusion
Next
From: "Joshua D. Drake"
Date:
Subject: Re: interface for "non-SQL people"