Re:PostgreSQL B-Tree index deduplication
by yxhuvud on Monday September 07, 2020 @02:55AM
(#24397182)
This is an great change, but I wonder, will it apply retroactively to indices from old databases or will the indices have to be rebuilt? Like, I understand that just upgrading the version won't reduce the sizes, but will reading and writing to the indices gradually reduce the size?
[ Parent
| on HN ]
Re:PostgreSQL B-Tree index deduplication
by petergeoghegan on Monday September 07, 2020 @03:06AM
(#24397238)
You will need to REINDEX after upgrading using pg_upgrade. Otherwise deduplication won't be applied in the old indexes at all.
These days it's possible to use the CONCURRENTLY option with REINDEX, which is much less disruptive.
Re:PostgreSQL B-Tree index deduplication
by CodeWriter23 on Monday September 07, 2020 @03:41AM
(#24397427)
In the second paragraph, the author links a couple of other articles that drill down some more. I almost missed those myself.