model-writtenrun 8793 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Mihail Nikalayeu reported in #1 that a prototype reusing the parsing snapshot for execution yielded a few percent improvement, prompting him to investigate why PostgreSQL took two snapshots.
- In #1, Mihail explained that the optimization had previously landed as d573e239f0 and been reverted by 532994299e because acquiring the execution snapshot before table locks caused user-visible anomalies.
- Mihail attached a comments-only patch in #1 documenting that hazard beside PopActiveSnapshot() in exec_simple_query, so future developers would not repeat the investigation.
- Alvaro Herrera committed the patch as db989184cd, polishing the wording and formatting and adding a link to the historical discussion without changing executable code.
- Alvaro confirmed application in #2, leaving the sole submitted patch landed with no outstanding work recorded.