model-writtenrun 40 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- shihao zhong reported that indexes upgraded from PostgreSQL 18 could miss rows after locale-related behavior changes, supplied a pg_upgrade warning and REINDEX-script patch, and separately requested documentation for stored tsvectors and changed stemmers #1.
- Jeff Davis questioned whether the changes warranted more than release notes and asked about additional affected stemmers; shihao supplied further text-search examples, argued for identifying affected indexes, and requested broader stemmer and fuzzystrmatch notes #2 #3.
- Andreas Karlsson favored release notes and argued that automatic checks for function behavior changes required a broader policy discussion; shihao cited the existing Unicode upgrade check as precedent but accepted documentation as a possible resolution #4 #5.
- Jeff committed a migration note explaining locale-provider changes, recommending reindexing text-search and pg_trgm indexes and recomputing stored tsvectors, then announced that commit and attached a separate stemmer-note patch 960626b936 #6.
- The stemmer patch landed unchanged, explaining the Dutch algorithm replacement and listing additional languages whose stems changed #6 123cad88f0.
- A separate discussion-derived commit expanded the fuzzystrmatch notes, moved them into Migration, and recommended rebuilding indexes that use the affected functions #3 14870d5a18.
- Jeff declined the pg_upgrade checks because complex queries would serve only one upgrade cycle and could miss indirect function usage, announced the release-note changes as committed, and said he would close the open item #7.
- shihao accepted the resolution and thanked Jeff after all three commits had landed; this final agreement therefore supplies no pre-commit review evidence #8.