Hi Bruce, One more item for the migration section. After the BUG #19749 fix (18740523a), older btree indexes on character columns must be rebuilt. The same goes for oidvector. pg_upgrade does not do it. Until then, index-only scans can return wrong values.
The attached patch adds a short entry that tells people to REINDEX them after upgrading. It is for REL_19_STABLE only. Would you add it? The fix was also back-patched to 14 through 18 (882fd416d6e on 18). The next minor release notes for those branches need the same REINDEX advice for character indexes. oidvector keeps deduplication there, so only 19 needs it. Thanks, Shihao
nocfbot-v1-0001-doc-bpchar-upgrade-note.patch
Description: Binary data
