>>>>> "David" == David Rowley <david.rowley@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)