On Tuesday, February 9, 2021, Wells Oliver <
wells.oliver@gmail.com> wrote:
OK, that seems to have made a huge difference. and ran very quickly, ~15 mins on a ~1TB database.
Is there a way to better understand what it did?
Read the documentation?
There's no way it rebuilt indexes in that amount of time. Also, as I said, I never did that going from 9->10->11->12, so it's interesting to me that it was so critical this time around.
I’m more inclined to think you did the analyze and just don’t remember - though its possible that the auto-vacuum daemon helped out behind the scenes.
David J.