PostgreSQL

2 articles

Web Engineering • Oct 13, 2026

Fix a Postgres Storage Bottleneck: 5 Symptoms, 9.2x on NVMe

Fix a Postgres storage bottleneck: 3 queries to confirm it, and a test where local NVMe hit 9.2x the TPS of gp3. Plus the durability bill nobody quotes.

9 min read

Web Engineering • Aug 19, 2026

Use Postgres for everything in production: 5 swaps, 1 cliff

Use Postgres for everything and four of the five swaps hold. The queue is the one that death-spirals: 383,000 dead tuples and 300ms locks at 800 jobs/sec.

8 min read