quick q re migration, index, stats

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

quick q re migration, index, stats

Scott Ribe-2
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?

Reply | Threaded
Open this post in threaded view
|

Re: quick q re migration, index, stats

Laurenz Albe
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



Reply | Threaded
Open this post in threaded view
|

Re: quick q re migration, index, stats

Scott Ribe-2
> 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.