Re: postgres 8.2 transaction id wraparound - Mailing list pgsql-admin

From Jim Nasby
Subject Re: postgres 8.2 transaction id wraparound
Date
Msg-id 3F9A6B45-F2E2-4F74-8AAF-E728BA88C791@decibel.org
Whole thread Raw
In response to postgres 8.2 transaction id wraparound  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List 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@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: vacuum fails with 'invalid page header' message
Next
From: Tom Lane
Date:
Subject: Re: Can't See Data - Plz Help!