Stuart Brooks wrote: > I am not using an ALTER table command but I am doing periodic ANALYZEs > to evaluate the table size. Could this be causing the problem? I notice > that stopping the ANALYZE calls appears to eliminate the canceled > autovacuum.
Why were you running ANALYZE on the first place? If it's just to see how many dead space there is, I suggest you peek into pg_stat_user_tables instead, which is less invasive. Autovacuum itself should run ANALYZEs as needed (and you can, of course, tune it if you feel it's not frequent enough in the default configuration). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
