pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedquick q re migration, index, stats
3+ messages / 2 participants
[nested] [flat]
* quick q re migration, index, stats
@ 2021-01-06 16:41 Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Ribe @ 2021-01-06 16:41 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: quick q re migration, index, stats
@ 2021-01-07 01:56 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2021-01-07 01:56 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: quick q re migration, index, stats
@ 2021-01-07 03:24 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2021-01-07 03:24 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On Jan 6, 2021, at 6:56 PM, Laurenz Albe <laurenz.albe@cybertec.at> 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-01-07 03:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-06 16:41 quick q re migration, index, stats Scott Ribe <scott_ribe@elevated-dev.com>
2021-01-07 01:56 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-01-07 03:24 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox