Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Дата
Msg-id 1180707595.15569.99.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Erik Jones <erik@myemma.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: shut down one database?
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: SQL Manager 2007 for PostgreSQL released