/Protocol
Slow Query Proof Before Index Changes
A daily research protocol for turning a slow-query complaint into a proof packet before recommending a production index.
Open notePostgres research topic
Postgres Indexing
Research on index safety, HypoPG shadow planning, write amplification, lock posture, and rollback-ready recommendations.
Published notes
Evidence-backed notes in this cluster.
Editorial queue
Upcoming notes for this topic.
May 6
When CREATE INDEX CONCURRENTLY Is Still Risky
Explain why concurrent index builds reduce blocking risk but still need lock, bloat, storage, and cancellation evidence.
Lock mode checklistIndex build storage budgetCancellation and invalid-index cleanup
May 12
Ranking Index Candidates by Proof, Not Hunch
Describe a scoring model for prioritizing index candidates by observed workload and shadow-plan evidence.
Fingerprint volumeShadow-plan deltaWrite-cost estimate