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

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 (view raw or flat)
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

pgsql-admin by date

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

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