On Mon, Aug 28, 2017 at 11:25 AM, Joe Conway <mail@xxxxxxxxxxxxx> wrote:
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.
-- 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.
Don.
Don Seiler
www.seiler.us
www.seiler.us
