postgres=# select * from sessions where video_id = 't6T3GPjEiS4';
Vibe Hacking Postgres
Review commit-LSN logging for destructive DDL and its test strategy.
session summary
The workshop resumed the patch that logs a recovery LSN when destructive DDL commits. Review showed AI-generated schema support used the wrong hook, added an uncalled function, and supplied a nondeterministic regression test unsuitable for raw LSN output; a TAP test was deemed necessary. Rather than finish the substantial cleanup live, they switched to optimizing the regression-test schedule with Cursor. Its reordered groups caused failures and thermal throttling, demonstrating that faster scheduling must respect test dependencies and stable benchmarking conditions.
timecodes
- Reality-checking AI-generated implementations
- Goal: log an LSN before destructive DDL
- Reviewing three patch iterations
- Why raw LSNs break regression-test output
- Finding unused schema-drop code
- Manual testing exposes missing schema logging
- Deferring patch cleanup and changing tasks
- Cursor rebalances the regression-test schedule