
Most PostgreSQL outages that trace back to file descriptor exhaustion get misread as a database problem. The failure is one layer down: the kernel runs out of file descriptors and PostgreSQL takes the hit. This post covers how that happens…


Cloudflare recently described how a slowdown in its billing pipeline was traced to contention inside the query planning stage of ClickHouse. The team profiled the bottleneck and patched ClickHouse to replace an exclusive lock with a shared…
PostgreSQL solves a bootstrapping puzzle with `data_directory`: how to find the config file before knowing where the data lives.
The Postgres community values feedback from testing of Beta releases, and with Docker it’s been easier to get pre-release versions up and running. With the recent announcement of PostgreSQL 19 Beta 1, let’s get that running and test some…