Tables with autovacuum_enabled=false still getting vacuumed

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Tables with autovacuum_enabled=false still getting vacuumed
Date: 2010-09-19 12:46:04
Message-ID: cone.1284900364.650647.23259.1000@shelca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to see the status of autovacuum_enabled for a table?

The reason I am asking is because I am seeing tables getting vacuumed which
I had set autovacuum_enabled to false. The autovacuum was already running
when I set the setting for a large number of tables.

If I had 5 tables
a
b
c
d
e

and I set autovacuum_enabled to false to all tables when autovacuum was in
the middle of autovacuum.. say on table c, should the last two tables d and
e be autovacuumed?

Postgresql 8.4.4 on CentOS, installed from RPM.

I see a case, BUG #3898, and a comment by Tom Lane
http://archives.postgresql.org/pgsql-bugs/2008-01/msg00222.php

In that post by Tom Lane he mentions "anti-wraparound vacuum" and a
pg_autovacuum table. From pg_stat_activity I see the comment "to prevent
wrap around". How can I prevent those too for selected tables? I have
lots of tables which are never going to be updated and are going through
that process. Said tables were freshly restored from another DB. Don't even
understand why they are getting the vacuum. Is pg_autovacuum still available
in 8.4.4? Don't see in \dS and can not select from it.

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-09-19 14:12:51 Re: how to insert multiple rows and get the ids back in a temp table (pgplsql)?
Previous Message Thom Brown 2010-09-19 11:49:15 Database not starting up for hot standby