Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Date: 2007-06-01 13:58:06
Message-ID: 1180706286.15569.94.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-01 13:58:25 Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Previous Message Tom Lane 2007-06-01 13:52:39 Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum