The case for boring technology
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.
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.
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.