Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

Csaba Nagy wrote:

> Trouble: the autovacuum daemon is still taking that table and vacuums
> it... how do I know ? So:
>
> select l.pid,c.relname from pg_locks l, pg_class c where l.pid not in
> (select distinct procpid from pg_stat_activity) and l.relation=c.oid and
> c.relkind='r';
>
>   pid  |  relname
> -------+------------
>  16317 | table_name
> (1 row)
>
> postgres@dbname:~$ ps auxww|grep auto
> postgres 16317  0.8  5.8 436008 240656 ?     D    13:26   0:55 postgres:
> autovacuum process   dbname

Probably autovacuum is worried about Xid wraparound so it tries to do a
database-wide vacuum.  In these cases it ignores the pg_autovacuum
disable.

Try reindexing the table; that should make the problem go away.  Also,
update to the latest of the 8.1 branch ASAP.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.