Indexes
A shop ledger page, 1899. Every line adds up.
Indexes vs Write Speed: Weighing the Tradeoff on Busy PostgreSQL Tables
Every index speeds reads and taxes writes. Learn how to find unused indexes, understand write amplification, and use partial indexes to keep the benefit with less cost.
4 min read
The Missing Index on a JOIN: The Beginner Fix for Slow PostgreSQL Queries
PostgreSQL does not index foreign key columns automatically. Learn how to spot the missing index behind a slow JOIN and add it safely with CREATE INDEX CONCURRENTLY.
4 min read