No video of the event yet, sorry!

Database corruption occurs when the data stored in a database becomes inconsistent, unreadable, or lost due to various factors. I will cover some database internals at a high level which are needed to understand the cause corruption and the potential solutions to address a specific corruption scenario. In this talk I will dissect a database corruption incident and the steps performed to recover the data. I will briefly discuss about the role of various extensions used for the analysis and recovery of the table data. This includes exploring some database internals such as Tuple headers, commit log, visibility map, tuple visibility rules, transaction id freezing and a few MVCC concepts.