postgres=# select * from sessions where video_id = '4KVaeJfWPas';
How to create Postgres patches with AI?
AI-assisted patch discovery, implementation, review, and submission.
session summary
The session developed a responsible AI-assisted patch workflow: treat prompts as engineering specifications, assign independent security, documentation, and testing reviewers, distrust praise, and use agents to summarize long CommitFest threads without surrendering judgment. They then applied that workflow to a patch that logs the LSN of DROP TABLE, enabling precise PITR after accidental deletion. The agent retrieved and rebased the patch, planned transaction, rollback, savepoint, and documentation tests, and continued adapting it to changed GUC infrastructure; final review remained pending.
timecodes
- What AI changes in Postgres hacking
- Specifications and independent reviewer roles
- Maintenance work and critical AI feedback
- AI-assisted patch and CommitFest review
- Advice for learning Postgres development
- GSoC as an entry into core hacking
- Starting a live DROP TABLE logging review
- PITR use case, tests, and patch rebase