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

From: Michal Szymanski <dyrex(at)poczta(dot)onet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
Date: 2009-10-09 23:01:13
Message-ID: b583dae1-cb3a-440a-9e4f-34ce25c715ee@b15g2000yqd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kelly Jones 2009-10-09 23:07:35 Wiki consisting of rows in a db table
Previous Message Merlin Moncure 2009-10-09 21:56:15 Re: interface for "non-SQL people"