Postgres Build 2021

It's easy to get misled into overconfidence based on the performance of powerful servers, given today's monster core counts and RAM sizes. However, the reality of high concurrency usage is often disappointing, with less throughput than one would expect. PostgreSQL is very particular about how it likes to deal with high concurrency, so let's look at potential pitfalls when you throw a lot of work at your database.