postgres 8.2 transaction id wraparound

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: postgres 8.2 transaction id wraparound
Date: 2007-01-02 23:09:19
Message-ID: 6992E470F12A444BB787B5C937B9D4DF07B4F58F@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

Regards

Sriram

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Olivier Boissard 2007-01-03 07:29:39 Re: table comparison
Previous Message Scott Marlowe 2007-01-02 20:11:32 Re: Invalid page header in block 211 of relation