model-writtenrun 7583 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Andres Freund traced a severe subtransaction performance regression to snapshot caching failing to advance xactCompletionCount on abort, preventing dead-tuple hint bits and the kill_prior_tuple optimization; he posted a counter increment and an index-growth regression test in #1, explaining that query results appeared unaffected.
- Tom Lane proposed a separate optimization to replace isObjectPinned catalog lookups with an OID cutoff and remove explicit pin entries from pg_depend in #2.
- Andres supported the OID-cutoff idea, measured substantial database-size savings from removing pin entries, and proposed extending implicit pinning to generated bootstrap objects in #3.
- Tom cautioned that pinning must include critical generated objects while excluding information_schema, suggesting clearer OID ranges or a recorded cutoff in #4.
- Andres examined the existing dependency entries and suggested that collation versioning and system constraints were the remaining exceptions to resolve in #5; this separate optimization remained exploratory.
- After unsuccessfully trying to provoke spurious test failures through concurrent activity, Andres announced the push in #6; 90c885cdab landed the entire patchset from #1 unchanged.