Conversation

Index corruption shouldnt happen... But life can be messy: okt.to/iAhu1s Gonna be discussing this live at the top of the hour: okt.to/DMX2sl

enterprisedb.com

Index Corruption in PostgreSQL: The Hidden Cost of Your 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...

2

2

Peter Geoghegan

@petervgeoghegan

Replying to

IMV the article should mention amcheck, which was specifically designed to detect all kinds of index corruption:

F.2. amcheck F.2.1. Functions F.2.2. Optional heapallindexed Verification F.2.3. Using amcheck Effectively F.2.4. Repairing Corruption The amcheck module provides functions that …

10:43 PM · May 23, 2020Twitter Web App

Replying to

@petervgeoghegan

Thanks Peter! Bruce & Vibhor talked about using amcheck a bit in our live conversation (starts about youtube.com/watch?v=J0zsZR) as part of the process of detecting these situations. Definitely an essential tool.

1