Schedule - PGDay Chicago 2024

How to detect and fix corruptions

Date: 2024-04-26
Time: 14:25–15:10
Room: Forum
Level: Advanced

When cleaning up some old data we found some corrupted pages in a toast table. Suddenly these corruptions blocked the vacuum and transaction wrap around was waiting for us just around the corner.

In this presentation I will guide you through the entire journey from detecting the corruption, unblocking the vacuum, decision making and fixing/mitigation the effects of the corruptions. For all of these steps you need different extensions and I will guide you through all of them. The extensions are great, but didn't provide us all the information we needed. To close the final gap we have been inspecting all pages of an index to find the missing links.

The goal for this presentation is to build confidence and skills for whenever you might face a corruption.

Speaker

Derk van Veen