Re: Problem with autovacuum and pg_autovacuum

Hello,

On Wed, 4 Jul 2007 18:04:35 -0400 Alvaro Herrera wrote:

> Most likely it is worried about XID wraparound, and those are precisely
> the tables that need urgent vacuumed because they haven't been vacuumed
> in a long time.

No, autovacuum is doing this with every run. Beside this, the database has
only some 10k changes per day. The wraparound was my first idea, but i
don't see a reason, why this should be happen with every autovacuum run.

> What do you do to keep them clear of dead tuples?

Most of this tables are just big (guestbook or forum entries as example).
But there will be no dead tuples, since the entries are inserted and never
changed. The main reason for putting this tables into the pg_autovacuum
table was to avoid the locks at all with normal autovacuum processing
and analyze the tables in a nightly maintenance window.

Kind regards

--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)