Schedule - PostgreSQL Development Conference 2024

Data Corruption Bugs: Diagnosis and Lessons

Date: 2024-05-30
Time: 11:30–12:20
Room: Sauder(2270)
Level: Advanced

Google Cloud SQL customers encounter PostgreSQL bugs corrupting databases, rarely but reproducibly. This talk will cover use of tools, especially amcheck, to grasp these bugs sufficiently to write fixes and test cases. Those fixes are now part of core PostgreSQL. It will include lessons for avoiding such bugs in future PostgreSQL development. Finally, it will share a diagnostic feature wish list.


Talk recorded at https://youtu.be/kNH94tmpUus.

Speaker

Noah Misch