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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
