Reading EXPLAIN ANALYZE
2026-10-16 • 14 min read • Steve Lloyd
Stop guessing why your query is slow — the database will tell you
Database Indexing Deep Dive
2026-08-21 • 14 min read • Steve Lloyd
The Data Structure That Decides If Your Query Takes 2ms or 2 Minutes
SQL Query Optimization Techniques
2026-01-16 • 21 min read • Steve Lloyd
Rewriting queries for performance, avoiding common pitfalls, using statistics
PostgreSQL TOAST: Advanced Storage Optimization
2025-07-11 • 11 min read • Steve Lloyd
Understanding the hidden storage mechanism that could make or break your database performance