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: Geoffrey||Date: 2007-01-05 21:29:50|
|Subject: vacuum fails with 'invalid page header' message|
|Previous:||From: Bruno Wolff III||Date: 2007-01-05 20:16:10|
|Subject: Re: PITR recovery|