Post Content
Video of a conference talk discussing how data corruption in PostgreSQL can severely impact database integrity, leading to service disruptions, data loss, and incorrect query results. This talk introduces a structured framework for diagnosing and addressing such issues using PostgreSQL’s built-in tools, Linux utilities, and advanced debugging techniques. Drawing from real-world scenarios, this framework highlights practical methods for detecting errors like “Could not read block,” “Cannot freeze committed xmax,” and “Could not locate valid checkpoint.”
The talk will also propose enhancements to PostgreSQL to simplify debugging and increase resilience. Suggestions include improving error messages to provide richer context, extending pg_verify_checksums to offer detailed block-level diagnostic reports, and introducing built-in debugging interfaces for easier analysis of backend state and block data.
By the end of this session, attendees will have a clear methodology to detect and resolve data corruption in PostgreSQL, gain insights into preventive measures, and explore ideas to enhance PostgreSQL’s support for such investigations. This talk aims to empower DB admin, developers, and PostgreSQL hackers alike, offering tools, strategies, and suggestions to ensure long-term reliability and improved debugging capabilities.
Nitin Jadhav is a Senior Software Engineer with extensive experience in database systems, particularly PostgreSQL. Currently working at Microsoft, Nitin has been part of the Azure Database for PostgreSQL team for the past few years. His primary responsibilities include onboarding new major and minor versions of PostgreSQL and integrating extensions into the managed database. Additionally, Nitin has been involved in handling customer issues, including analyzing and resolving various database corruption problems, and contributing to the PostgreSQL community as needed. Before joining Microsoft, Nitin worked at EDB, where he focused more on contributing to the PostgreSQL community.
Palak Chaturvedi is a Software Engineer at Microsoft, deeply engaged in the world of PostgreSQL. With a passion for databases and distributed systems, she loves uncovering hidden bugs and solving complex engineering challenges. Since graduating, she has spent the past year working on PostgreSQL, tackling everything from data corruption issues to replication intricacies. She is always eager to learn new technologies and push the boundaries of what’s possible. When she is not debugging or optimizing systems, you’ll find her immersed in books, gaming, or exploring the next big challenge.
► Video bookmarks:
00:00 Introduction
02:23 What is Data Corruption?
03:16 Causes of Corruption
10:49 Analysis of a Few Corruption Cases
21:35 Best Practices to Handling Corruption Cases
23:08 How to detect corruption
29:36 Corruption Recovery
Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com
Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist
Let’s connect:
LinkedIn – https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://twitter.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com
Azure Database for Postgres LinkedIn: https://www.linkedin.com/company/azure-database-for-postgresql/
_________________________________
#PosetteConf #PostgreSQL #DataCorruption Read More Microsoft Developer
