4 ms·
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
by petergeoghegan 6y ago
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.