On Wed, Sep 12, 2012 at 5:00 PM, Wells Oliver <wellsoliver@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
