Re: quick q re migration, index, stats

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.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com