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? 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.
Yeah. Running that now. Honestly, I went from 9 to 10 to 11 to 12 without doing that in prod, and it was marvelous. 13 hit a wall, and I'm not sure why.
On 2/9/21 12:00 PM, Wells Oliver wrote: > Hey guys, I just upgraded a DB from 12 to 13. In testing this seemed to go > well, but it seems like most of my queries are not using the indexes after > the upgrade, so everything is quite so. > > Is there a general need to REINDEX after upgrading to 13, or might there > be another issue? The configuration parameters are the same as they were > persisted via pg_upgradecluster.
Did you also change or upgrade the distro, or modify the collation? (That's an automatic need to rebuild indices.)