Re: Auto ANALYZE criteria

On Mon, Sep 20, 2010 at 6:28 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Joe Miller <joe(dot)d(dot)miller(at)gmail(dot)com> 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.