News for hackers. Stuff that matters.
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?
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.