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: 3F9A6B45-F2E2-4F74-8AAF-E728BA88C791@decibel.org (view raw or flat)
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      http://enterprisedb.com      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-2014 The PostgreSQL Global Development Group