My Journey in PostgreSQL bug fixing
summary
Walks through three real bug stories: one found and located to the exact commit with git bisect, one that crashes an assertion tracked down with a GDB watchpoint on Portal->snapshot transitions, and one where logical decoding builds the wrong MVCC snapshot so a catalog-modifying subtransaction is invisible. Shows initial naive patches, the debugging commands and backtrace lines that pointed to the fix, and the final committed or back-patched changes that resolve each failure.
AI-written summary · about
chapters (7)
- 0:00Introduction to journey
- 1:25What this talk covers
- 3:11Bug discovery context
- 5:30First bug example
- 12:10Second bug example
- 26:39Third bug example
- 44:46Q&A session
related talks
42mMy Journey in PostgreSQL bug fixing
47mBeginner's guide to PostgreSQL Hacking
50mHacking on Postgres: An Overview
52mData Corruption Bugs: Diagnosis and Lessons
20mDebugging Data Corruption in PostgreSQL
50mPostgreSQL hacker tips
37mWhen it all goes Wrong (with Postgres)
56mPostgreSQL at low Level: stay curious!