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.
