FINDING (AND FIXING) A SILENT THROUGHPUT CEILING IN POSTGRESQL

Summary from the TLDR DevOps newsletter

PostgreSQL throughput can stall under heavy concurrent inserts even when CPU and storage have spare capacity, as writers queue behind relation extension locks. In a HammerDB benchmark, distributing writes across hash partitions reduced contention and increased throughput 7.2× on the same hardware.