| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Sriram Dandapani <sdandapani(at)counterpane(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: postgres 8.2 transaction id wraparound |
| Date: | 2007-01-05 20:44:24 |
| Message-ID: | 3F9A6B45-F2E2-4F74-8AAF-E728BA88C791@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2007-01-05 21:29:50 | vacuum fails with 'invalid page header' message |
| Previous Message | Bruno Wolff III | 2007-01-05 20:16:10 | Re: PITR recovery |