article
June 5, 2022
4 min read
0 views
Postgres at Scale: The Index Bloat Problem Nobody Warns You About
Dead tuples from MVCC accumulate in indexes differently than in tables. We hit a production stall from index bloat on a 400 GB table. Here is how we diagnosed and fixed it.
Dead tuples from MVCC accumulate in indexes differently than in tables. We hit a production stall from index bloat on a 400 GB table. Here is how we diagnosed and fixed it.
Overview
This note is part of the field-notes archive generated for this site. The summary below is the published excerpt; you can expand the full write-up anytime in the CMS.
Related notes
Tags
- postgres
- database
- performance
- indexing
- production
M
Manish Bookreader
Electronics enthusiast, Embedded Systems Expert, Linux/Networking programmer, and Software Engineer passionate about AI, electronics, books, and cooking.
