Postgres at the edge of its patience

A single Postgres instance can take you much further than the internet suggests, and then it suddenly cannot. Tomas maps the five walls teams hit between ten thousand and ten million users.

For each wall: how to see it coming, what to try before sharding, and the one change that bought his team a further eighteen months.