Episode 7 - Index Corruption in PostgreSQL: The Hidden Cost of Your Queries
Listen now
Description
A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as errors reading tables due to a missing file—that is rather straightforward, of course. However, a corrupt index is not as obvious as a corrupt table. More often than not to find if indeed there is index corruption, one needs to observe the behavior (execution times) and results of the queries themselves. In this episode, we dive into questions and quagmires around index corruption and related issues. For more information on this topic, visit this blog: https://www.enterprisedb.com/blog/how-to-fix-postgresql-index-corruption-deal-repair-rebuild Learn more about our weekly live Q&A sessions here: ps://www.enterprisedb.com/postgres-pulse  Subscribe to the podcast to listen to Postgres Pulse episodes on demand!
More Episodes
PgBadger is a PostgreSQL log analyzer with fully detailed reports and graphs. It is open source and is considered lightweight. While it doesn’t have the depth, probe capability or tool integration that EDB Postgres Enterprise Manager does, it’s particularly useful in helping you to analyze your...
Published 05/26/20
When it comes to dealing with poor database and query performance, it’s a daunting task to venture into the dark cavern of query planning and optimization, but fear not! EXPLAIN is our friend in those dark and lonely places. This session covers EXPLAIN and how it is certainly one of the most...
Published 05/04/20
Planning is key to PostgreSQL backup and recovery. Every environment has its own challenge—and even if we have multiple database clusters in the same organizations, the backup requirements for those might also vary. Therefore, it is important to list down the situations we might need to recover...
Published 04/30/20