series
Series
Multi-part deep dives on SQLPress. Each series walks one topic from first principles to production, in reading order.
2 series
- sql-fundamentals · 1 partIndexing From First PrinciplesThree parts on index design driven by structure rather than rules of thumb — column order, what covering an index really costs, and the case where an index is valuable because of what it leaves out.
- Composite Indexes: One Ordering, Not Three
- postgresql · 1 partReading Execution PlansThree parts on turning a plan from a wall of text into a diagnosis — which EXPLAIN variant answers which question, the order to read a plan tree in, and the one comparison that localizes most problems.
- EXPLAIN, ANALYZE, BUFFERS: Three Different Questions