On Tue, 9 Jun 2020 at 15:41, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> David Rowley <dgrowleyml(at)gmail(dot)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