model-writtenrun 7214 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Alexander Lakhin reported that REINDEX CONCURRENTLY fails a snapshot assertion with 1 KB blocks because index swapping can update toasted catalog tuples without a suitable snapshot, and suggested larger tuples could expose the same issue with ordinary blocks #1.
- Alexander supplied diagnostic instrumentation and reported that check-world also exposed missing snapshots during concurrent partition detachment and logical replication subscription updates #2.
- Michael Paquier acknowledged the problem but offered no solution or substantive patch review in his reply #3.
- Andres Freund confirmed the issue and proposed moving assertions into higher-level heap operations so failures would be detected even without actual TOAST access, allowing exceptions for bootstrap processing #4.
- The supplied thread ended with Andres recommending broader assertions followed by fixing each exposed caller; no production fix or landing was reported in the thread #5.
- Nathan Bossart subsequently committed snapshot fixes and broader heap assertions on May 30, 2025 in 706054b11b.
- The PostgreSQL 13 backport b7ba2c0308 omits the broader assertions because their supporting function was unavailable there; its implementation is now attributed to the later development and review in thread #50222, with this thread providing the original report and diagnostic investigation.
- The commit explains that replication-origin issues remained unfixed on older branches because removing an existing catalog TOAST table was impractical and the low-severity alternative required substantial changes 706054b11b.