Ed L. wrote:
Does autovac maintain its state/counters across restats as to who
need to be vacuumed/analyzed? Or does killing autovac cause it
to reset the counters for the vacuum/analyze threshholds?
Depends on the version. The contrib autovacuum does not maintain state
through a restart. The integrated version (8.0 and 8.1) can maintain
state as long as you don't have the stat system configured to reset on
restart.
Matt
---------------------------(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
