Postgres Pro
Downloads
Home   >   mailing lists

Why is postgres autovacuuming a table that is never updated? - Mailing list pgsql-general

From Joseph S
Subject Why is postgres autovacuuming a table that is never updated?
Date
Msg-id fv7qpm$1r0u$1@news.hub.org
Whole thread Raw
Responses Re: Why is postgres autovacuuming a table that is never updated?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Why is postgres autovacuuming a table that is never updated?  (Andrew Sullivan <ajs@commandprompt.com>)
List pgsql-general
Tree view 
I'm running 8.2.6.  I have a log table that is always INSERTed to, and
no updates or deletes are ever run on.  For some reason the autovacuum
decided it needed to vacuum this table, and it is slowing down my
production server.

So my questions are:
  1) Why vacuum, if this table is never updated?
  2) How can I use pg_autovacuum table to disable autovac for this
table?  The docs are not clear on how to do this.

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Help! ERROR: could not open relation
Next
From: Alvaro Herrera
Date:
Subject: Re: Why is postgres autovacuuming a table that is never updated?