Re: enabling autovacuum

["Matthew T. O'Connor" <matthew(at)zeut(dot)net>]

Jeremy Harris wrote:
> Chander Ganesan wrote:
> > Inserts don't generate dead tuples, and AVD looks at obsolete 
> > tuples..  As such,  I wouldn't expect AVD to kick off until after you 
> > did a mass delete...assuming that delete was sizable enough to 
> > trigger a vacuum.
>
> Ah, that would explain it - thankyou.   So I need to retreat to
> the question of why the weekly vacuum permits the observed bloat.
> Any ideas?   More information that I could gather? 

Autovacuum will kick off an analyze if you do enough inserts however.