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) > > [EMAIL PROTECTED]:~$ 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
