postgresql
- PostgreSQL Query Planner Internals: How the Cost-Based Optimizer Chooses a Plan
An overview of PostgreSQL's planner: cost model, statistics, join ordering, and why the wrong plan gets chosen sometimes.
- Why your database connection pool is probably misconfigured
Connection pools look simple until your app falls over at 3am. Here's the math behind sizing them correctly, and the mistakes that get everyone eventually.
- From ILIKE '%query%' to search that feels instant
LIKE queries work fine until your table grows. The real path from a slow sequential scan to search that returns results as you type.