A few months ago I was looking at why a PostgreSQL instance was running at 94% memory on a server that, by all accounts, should have had plenty of headroom. The queries were fast, the data volume was modest, and CPU was barely touched.

The culprit was 280 open connections.

No single connection was doing anything particularly expensive. But each...