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:46:48
Message-ID: 1180712808.15569.113.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gonzales 2007-06-01 15:51:02 Re: Slightly OT.
Previous Message Tony Caduto 2007-06-01 15:40:35 Re: SQL Manager 2007 for PostgreSQL released