On Mon, Aug 28, 2017 at 11:25 AM, Joe Conway <mail(at)joeconway(dot)com> wrote:
> Well some values are maintained by analyze, but with a 0.1 scale factor
> for analyze that still means 7 million rows or so threshold for that to
> happen.
I think what I'm failing to understand is how it got so big without an
autoanalyze kicking in at some point to keep relatively in sync. To my
knowledge, autovacuum was never disabled here (I'm new, so I can't say with
any certainty that it never was). I would expect as the inserted rows grow
past a certain threshold, it would kick in an occasional analyze so it
wouldn't get over 2 orders of magnitude off from 170K to 71M.
Don.
--
Don Seiler
www.seiler.us