postgres=# select * from sessions where video_id = '5lN775a5geI';
Vibe Hacking Postgres
Review B-tree merge blockers and prototype commit-LSN logging for DROP TABLE.
session summary
After reviewing UUIDv7 and amcheck support for GIN in Postgres 18, the group discussed responsible AI-assisted hacking and briefly parked the B-tree merge work over unresolved scan concurrency. Most of the session revisited recovery from accidental DROP TABLE: they asked an agent to extend transaction callbacks with the commit LSN and build a logging extension. The prototype found table names through object-access hooks, but cleanup timing and an invalid commit LSN prevented a working result, leaving the design unfinished.
timecodes
- Postgres 18 outcomes: UUIDv7 and GIN checks
- Responsible AI-assisted Postgres hacking
- Why the B-tree merge prototype was paused
- Revisiting a recovery landmark for DROP TABLE
- Prompting a callback and extension prototype
- Building and loading the DROP TABLE extension
- Combining object-access and commit callbacks
- Recovery-event catalogs and the invalid-LSN blocker