On Fri, Feb 13, 2009 at 3:21 PM, Joshua D. Drake <j...@commandprompt.com> wrote: > Hello, > > I found this today. Note, auto vacuum has been disabled for this > relation for a very, very long time. At the very end you will see that > this relation has been autovacuumed previously as well. We have a manual > cron to vacuum this table every hour so I am unsure why autovacuum is > doing what it is doing. > > app=# select * from pg_autovacuum where vacrelid = '21474846'; > -[ RECORD 1 ]----+--------- > vacrelid | 21474846 > enabled | f > vac_base_thresh | 0 > vac_scale_factor | 0 > anl_base_thresh | 0 > anl_scale_factor | 0 > vac_cost_delay | 0 > vac_cost_limit | 0 > freeze_min_age | 0 > freeze_max_age | 0 >
i was bitten for this already... the problem is that you have all parameters in 0... they should be -1 (specifically max_freeze_age) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers