Thread: postgres 8.2 transaction id wraparound
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
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)