Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Date
Msg-id 1180707595.15569.99.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Erik Jones <erik@myemma.com>)
List pgsql-general
Tree view 
On Fri, 2007-06-01 at 15:58, Alvaro Herrera wrote:
> Try reindexing the table; that should make the problem go away.  Also,
> update to the latest of the 8.1 branch ASAP.

Reindexing won't work, it would mean hours of downtime. I plan to move
the DB to 8.2 via slony in ~2-3 weeks, that should take care of the
bloating too.

Regarding upgrade, I have to use the CVS version because I have some
local patches to apply. Now what is more recommended, use the latest
version on the REL8_1_STABLE branch or stick with REL8_1_9 ? I checked
and there are quite a few changed files after REL8_1_9.

Thanks,
Csaba.

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: shut down one database?
Next
From: Guillaume Lelarge
Date:
Subject: Re: SQL Manager 2007 for PostgreSQL released