3 ms·
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
by yxhuvud 6y ago
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?
- petergeoghegan 6y agoYou 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.
- CodeWriter23 6y agoIn the second paragraph, the author links a couple of other articles that drill down some more. I almost missed those myself.