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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
