On Wed, 2021-01-06 at 09:41 -0700, Scott Ribe wrote:
> As part of migration to PG 13, I'll be updating Linux as well, thus complete reindex required.
> So just confirming that I still need to manually run vacuumdb --all --analyze-in-stages?
> In other words, reindexing doesn't capture stats as it processes the rows?
You are right, you still need to calculate statistics.
By the way, you only need to rebuild those indexes that contain string data types,
unless you want to make use of the new index compression feature in v13.
> On Jan 6, 2021, at 6:56 PM, Laurenz Albe <[hidden email]> wrote:
> By the way, you only need to rebuild those indexes that contain string data types,
> unless you want to make use of the new index compression feature in v13.
Thanks for pointing that it out; it hadn't occurred to me. But most of our indexes are strings, and we do have some numeric types that can have duplicates, so I think I'll be lazy and reindex all instead of trying to pick and choose.