Skip site navigation (1) Skip section navigation (2)

Re: postgres 8.2 transaction id wraparound

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Sriram Dandapani <sdandapani(at)counterpane(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres 8.2 transaction id wraparound
Date: 2007-01-05 20:44:24
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
On Jan 2, 2007, at 6:09 PM, Sriram Dandapani wrote:
> I read the release notes for 8.2 which mentioned that transaction  
> id wraparounds are now on a per-table basis versus database-wide.  
> Currently for 8.1 I issue a vacuumdb –a command which takes a coule  
> of days due to the size of the databse.
> What is the equivalent command in 8.2 (assuming autovacuum is  
> turned off)
vacuumdb -a will still work, though you might do better to let  
autovacuum take care of things since it will only vacuum tables that  
need to be vacuumed.
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      512.569.9461 (cell)

In response to

pgsql-admin by date

Next:From: GeoffreyDate: 2007-01-05 21:29:50
Subject: vacuum fails with 'invalid page header' message
Previous:From: Bruno Wolff IIIDate: 2007-01-05 20:16:10
Subject: Re: PITR recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group