PostgreSQL Indexes Explained Through Queries That Actually Need Them
Choose PostgreSQL indexes from real SaaS queries. Work through composite, partial, expression, covering, and GIN indexes with a reproducible dataset.
Databases articles
Start with the query and the data it needs. These articles explain how to model relational data, choose indexes, understand query plans, and make database changes with evidence.