Postgres Pro
Downloads
Home   >   mailing lists

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

From Michal Szymanski
Subject transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
Date
Msg-id b583dae1-cb3a-440a-9e4f-34ce25c715ee@b15g2000yqd.googlegroups.com
Whole thread Raw
Responses Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
List pgsql-general
Tree view 
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?
How to check using SQL if  transaction ID is close to wraparound?

Michal Szymanski
http://blog.szymanskich.net

pgsql-general by date:

Previous
From: Kelly Jones
Date:
Subject: Wiki consisting of rows in a db table
Next
From: Alvaro Herrera
Date:
Subject: Re: Regexp confusion