Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Erik Jones <erik(at)myemma(dot)com>, 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 15:09:00
Message-ID: 1180710540.15569.108.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[snip]
> You don't need to reindex, just update.

I was pretty sure I've seen the error reported and the fix too, the
thing is relatively harmless except the vacuum troubles. And considering
that the table itself does not need vacuuming, it would be even more
harmless if it wouldn't block other stuff and if XID wraparound wouldn't
be a problem.

> HEAD from the branch is certainly better as it contains some extra
> fixes (particularly one for a bug introduced in 8.1.9 which may bite you
> if you just pick that one ... see about bug #3116)

OK, I'll go with head.

Thanks,
Csaba.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2007-06-01 15:11:30 Re: warm standby server stops doing checkpointsafterawhile
Previous Message Joshua D. Drake 2007-06-01 15:08:44 Re: Slightly OT.