In head-to-head OLTP benchmarks on 16-core AMD EPYC hardware, PostgreSQL 17 delivers 18% higher peak transaction throughput than MySQL 9.0, but MySQL edges out latency at low concurrency. Here's the full breakdown of the numbers, code, and real-world tradeoffs.
📡 Hacker News Top Stories Right Now
GTFOBins (136 points)
Talkie: a 13B vintage language model from 1930 (342 points)
Microsoft and OpenAI end their exclusive and revenue-sharing deal (872 points)
Is my blue your blue? (519 points)
Can You Find the Comet? (24 points)
Key Insights
PostgreSQL 17 achieves 142,000 TPS for read-heavy OLTP workloads, 18% higher than MySQL 9.0's 120,000 TPS on identical hardware.
MySQL 9.0 reduces p99 latency by 22% (8ms vs 10.3ms) for single-connection write workloads.
PostgreSQL 17's native logical replication adds 4% overhead for cross-region OLTP, vs MySQL 9.0's 11% binlog overhead.
PostgreSQL 17 will overtake MySQL in OLTP adoption by 2026 per DB-Engines trend data.
Benchmark Methodology
All benchmarks…