Article

You added an index and the query is still slow. Before you reach for a bigger database, check the three usual suspects: a function wrapped around the column, a type mismatch, or a filter the planner thinks is cheap.

Popular
An open book beside a cup of tea

Every new technology comes with unknown unknowns. The boring stack you already understand has had its sharp edges filed off by a decade of other people's outages.

Why your database index isn't being used

Good debugging isn't magic, it's method. Reproduce it, shrink it, form one hypothesis, and change exactly one thing. Then write down what you learned so you never debug it twice.

Popular
An open book beside a cup of tea

I'm Alex, a backend engineer who has spent fifteen years building and breaking production systems. Byte Notes is where I write down the things I wish someone had told me sooner.

Article

You added an index and the query is still slow. Before you reach for a bigger database, check the three usual suspects: a function wrapped around the column, a type mismatch, or a filter the planner thinks is cheap.

Popular
An open book beside a cup of tea

Every new technology comes with unknown unknowns. The boring stack you already understand has had its sharp edges filed off by a decade of other people's outages.