Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Дата
Msg-id 1180706286.15569.94.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> If that table has a TOAST table you might need to mark the toast table
> as disabled too.  Or maybe it's forcing a vacuum because it's worried
> about XID wraparound?

OK, that might be the case, as I guess there are tables which were not
successfully vacuumed in the last few months (DB wide vacuum never
finished, and this system was stable enough before that I only noticed
this problem recently when performance started to degrade considerably).
Is there a way I can check the imminence of XID wraparound ?

Thanks,
Csaba.



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum