System Design Aug 4, 2026 10 min read
Composite, Covering, and Partial Indexes Explained
Learn to design composite, covering, and partial PostgreSQL indexes from real query predicates, ordering, projections, selectivity, and write-cost evidence.
Tag
Indexes
2 articles with this tag. Follow these related notes when you want a narrower study path.
System Design Jun 28, 2026 5 min read
Database Indexes Explained
Learn how database indexes work, why they speed up reads, when they slow down writes, and how backend developers should choose indexes.