War Story: We Ditched MySQL 8.0 for Neon 0.18 Postgres and Cut Query Latency by 20%

At 2:17 AM on a Tuesday, our p99 API query latency spiked to 4.2 seconds, MySQL 8.0’s InnoDB buffer pool was thrashing, and our on-call engineer was ready to quit. Three months later, after migrating to Neon 0.18 Postgres, that same query runs at 210...