Date: 2026-01-30
Time: 15:10–16:00
Room: Ballroom B
Level: Advanced
For me, database corruptions are the most frightening problems to face. I see it as my primary task to keep the data safe and available, and corruptions are an especially tough nut to crack when you encounter them. They can be many years old, and restoring from a backup might not be an option. I've now faced corruptions multiple times and can deal with them with confidence. I'd like to show you how you can handle corruptions as well, without losing any data or have to rely only on your backups.
There are multiple ways to corrupt data yourself, but today I'll focus on transaction corruptions caused by sub-optimal planning on my side, or maybe a bug in the system, I am still not totally sure.
Corruptions are hard to fix because they require a deep understanding of multiple parts of the database. In this presentation, I'll guide you through the entire journey, from detecting the corruption and unblocking the vacuum, to decision-making, and finally mitigating and fixing the problem. For all these steps, you'll need different extensions, and I'll walk you through each of them.
After this presentation, you should have the confidence to start tackling corruptions yourself. With the help of our blog at https://www.adyen.com/knowledge-hub/database-corruption-in-postgresql, you'll be the company hero who ensures the company's data remains secure and recoverable, even in the face of corruption.