On Mon, Sep 20, 2010 at 6:28 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > Joe Miller <joe.d.miller@xxxxxxxxx> wrote: > >> I can set up a cron job to run the ANALYZE manually, but it seems >> like the autovacuum daemon should be smart enough to figure this >> out on its own. Deletes can have as big an impact on the stats as >> inserts and updates. > > But until the deleted rows are vacuumed from the indexes, an index > scan must read all the index entries for the deleted tuples, and > visit the heap to determine that they are not visible. Does a > manual run of ANALYZE without a VACUUM change the stats much for > you, or are you running VACUUM ANALYZE? > > -Kevin > The autovacuum is running correctly, so the deleted rows are being removed. All I'm doing is an ANALYZE, not VACUUM ANALYZE. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
