Re: Auto ANALYZE criteria

Joe Miller  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