Diagnose PostgreSQL index bloat, write amplification, and buffer cache hit ratios with system-catalog SQL queries, then reindex with zero downtime.
Continue reading
Diagnosing PostgreSQL Index Bloat, Write Amplification, and Buffer Cache Hit Ratios
on SitePoint.
