postgres=# select * from sessions where video_id = '0nFGVCpQDec';
Hacking Postgres with Andrey and Nik
Redesign DROP TABLE recovery logging around the commit LSN.
session summary
The session opened with recent Postgres work on GIN amcheck, corruption detection, read streams, and pg_stat_statements sampling, then returned to the DROP TABLE recovery patch. The patch logged an attempted drop before commit, producing misleading landmarks after rollback. They redesigned transaction callbacks to receive the commit LSN, manually changed the commit path after an AI attempt stalled, and demonstrated commit-only logging. Remaining work included two-phase commit, schema/OID formatting, tests, and incorporating Jim Jones's review before a new version.
timecodes
- GIN amcheck and corruption detection
- Recent read-stream and statistics work
- Revisiting DROP TABLE recovery logging
- Why attempted-drop logging is ambiguous
- Testing an AI coding agent on Postgres
- Passing the commit LSN to transaction callbacks
- Implementing the core changes manually
- Working result and remaining patch tasks