>>>>> "David" == David Rowley <david.row...@2ndquadrant.com> writes:

 >> It happens 12 or 13 times on my machine, then does not happen again
 >> for 60 seconds, then happens again.

 David> Setting autovacuum_naptime to 10 seconds makes it occur in 10
 David> second intervals...

Analyze (including auto-analyze on a different table entirely) has a
snapshot, which can hold back OldestXmin, hence preventing the
all-visible flag from being set.

-- 
Andrew (irc:RhodiumToad)

Reply via email to