Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: 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:52:39
Message-ID: 24684.1180705959@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> System: postgres 8.1.3p, not a released version but a CVS checkout
> somewhere after 8.1.3 was released.

Updating to 8.1.6 or later would fix your "failed to re-find parent key"
problem.

> Trouble: the autovacuum daemon is still taking that table and vacuums
> it... how do I know ?

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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2007-06-01 13:58:06 Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Previous Message Frank Wittig 2007-06-01 13:51:19 Re: warm standby server stops doing checkpointsafterawhile