model-writtenrun 7814 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Duncan Sands supplied a Python reproducer showing that concurrent updates could corrupt a GiST index on PostgreSQL 13.1, causing indexed lookups to miss existing rows #1.
- Andrey Borodin reproduced the failure and suspected that root downlinks were not being adjusted after concurrent splits #2.
- Heikki Linnakangas reproduced the problem down to PostgreSQL 12 and bisected it to the refactoring of deleted GiST page checks #3.
- Heikki posted a patch replacing an incorrect && with || in the concurrent split/deletion check and adding an assertion against inserting into deleted pages #4.
- The patch landed unchanged as 6b4d3046f4, and Heikki announced backpatches through PostgreSQL 12 for the next minor release #6.
- After Tom Lane asked which indexes required repair, Heikki advised reindexing all GiST indexes because any with concurrent inserts might be corrupt; the proposed GiST amcheck extension could detect this corruption but was not yet committed #7 #8.