On Tue, 9 Jun 2020 at 15:41, Tom Lane <t...@sss.pgh.pa.us> wrote: > > David Rowley <dgrowle...@gmail.com> writes: > > It does seem plausible, given how slow prion is that autovacuum might > > be trigger after the manual vacuum somehow and building stats with > > just 1k buckets instead of 10k. > > Hmm ... that's a plausible theory, perhaps. I forget: does autovac > recheck, after acquiring the requisite table lock, whether the table > still needs to be processed?
It does, but I wondered if there was a window after the manual vacuum resets n_ins_since_vacuum and between when autovacuum looks at it. David
