Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
Why is postgres autovacuuming a table that is never updated?
- From: Joseph S <jks(at)selectacast(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Why is postgres autovacuuming a table that is never updated?
- Date: Tue, 29 Apr 2008 14:52:39 -0400
- Message-id: <fv7qpm$1r0u$1(at)news(dot)hub(dot)org>
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.
- Follow-Ups:
- Re: Why is postgres autovacuuming a table that is never updated?
- From: Andrew Sullivan
- Re: Why is postgres autovacuuming a table that is never updated?
- From: Alvaro Herrera
- Re: Why is postgres autovacuuming a table that is never updated?
- Prev by Date: Re: String Comparison and NULL
- Next by Date: Re: Why is postgres autovacuuming a table that is never updated?
- Previous by thread: Delete xml node from xml-document
- Next by thread: Re: Why is postgres autovacuuming a table that is never updated?
- Indexes: