Indexes, query plans, transactions, and data modeling. Practical PostgreSQL, SQL, and distributed-data engineering.
6 articles
PostgreSQL Performance: A Practical Guide to Indexes, Query Plans, and PoolingA practical Postgres performance guide: read query plans with EXPLAIN, index the right columns, kill N+1 queries, and pool connections so the database scales.
Postgres JSONB: When to Use It and When It BitesA field guide to PostgreSQL JSONB: the genuinely good use cases, GIN indexing, and the modeling traps that bite teams later.
N+1 Queries: The Silent Performance KillerWhat the N+1 query problem is, why ORMs cause it by default, how to spot it, and the patterns that eliminate it for good.
Connection Pooling: Why Your Database Falls Over at 100 UsersWhy a database that handles 20 connections collapses at 100, and how connection pooling with tools like PgBouncer fixes it.
How Postgres index-only scans avoid touching the table heap, when they kick in, and how the visibility map quietly decides everything.
A practical mental model for how database indexes really work, why they speed up reads, and the hidden costs you pay on writes.
