On Wed, Sep 12, 2012 at 5:00 PM, Wells Oliver <wellsoliver(at)gmail(dot)com> wrote:
> We have a few tables that are updated nightly on the order of deleting and
> inserting 500k records.
Out of how many in total?
> 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.
That is one day's worth. If the tables undergo churn once a day, and
get vacuum once a day, that seems like a nice steady state. I
wouldn't worry about it.
Cheers,
Jeff