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 1180712808.15569.113.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
List pgsql-general
On Fri, 2007-06-01 at 17:40, Alvaro Herrera wrote:
> Huh, why do you say that it doesn't need any vacuuming?

This table is only inserted and rarely deleted, so other than the XID
wraparound vacuuming it is not critical. Of course it will need vacuum
finally, but it can survive months without it - or till the XID
wraparound occurs, which I can't estimate yet if in danger or not... how
could I check that ? (I can probably find the answer if looking harder
though).

Cheers,
Csaba.


pgsql-general by date:

Previous
From: gonzales@linuxlouis.net
Date:
Subject: Re: Slightly OT.
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum