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

There are no comments on this comment yet.