Postgres Pulse: Index Corruption in PostgreSQL - The Hidden Cost of Your Queries | Database Queries

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 session, we dive into questions and quagmires around index corruption and related issues.