Re: Problem with autovacuum and pg_autovacuum

Andreas 'ads' Scherbaum wrote:
>
> Hello,
>
> we got a small problem with auto_vacuum: since we have some big tables
> which have heavy read/write access, we tried to exclude this tables
> from autovacuum:
>
> database1=# select vacrelid,enabled,(select relname from pg_class where oid=vacrelid) as relname from pg_autovacuum;
> vacrelid | enabled | relname
> ----------+---------+----------------------
> 42041 | f | guestbook
> 42344 | f | forum_threads
> 42406 | f | forum_thread_entries
> 41937 | f | user_online
> 42255 | f | forum_fora
> 41570 | f | users
> 41694 | f | user_data
> (7 rows)

Most likely it is worried about XID wraparound, and those are precisely
the tables that need urgent vacuumed because they haven't been vacuumed
in a long time.

What do you do to keep them clear of dead tuples?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support