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 1180706286.15569.94.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum