We have a few tables that are updated nightly on the order of deleting and
inserting 500k records.
I assumed autovacuum would do its thing and clean up the dead tuples, but
in looking at pg_stat_user_tables, I notice there are lots and lots of dead
tuples, on the order of a 500-600k.
What can I do about this? Why isn't autovacuum cleaning these tables? Is
this number of dead tuples acceptable?
Lastly, would it make sense to do a weekly full manual vacuum + analyze?
Thanks.
--
Wells Oliver
wellsoliver(at)gmail(dot)com