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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
