In 2024, 68% of production database outages traced to suboptimal query plans, according to a Datadog study of 12,000+ clusters—yet 72% of senior engineers admit they’ve never read a line of optimizer source code.
📡 Hacker News Top Stories Right Now
Ghostty is leaving GitHub (1947 points)
Before GitHub (321 points)
How ChatGPT serves ads (200 points)
Show HN: Auto-Architecture: Karpathy's Loop, pointed at a CPU (33 points)
Regression: malware reminder on every read still causes subagent refusals (169 points)
Key Insights
PostgreSQL 16’s parallel sequential scan optimizer reduces full-table scan latency by 47% on 16-core ARM instances (Graviton3)
MySQL 8.2’s new cost model improves join order selection accuracy by 32% for star schema workloads vs MySQL 8.0
Switching from MySQL 8.0 to 8.2’s optimizer cut monthly RDS costs by $14k for a 4-engineer team at a fintech startup
By 2026, 80% of PostgreSQL and MySQL optimizer improvements will target machine learning-driven cardinality estimation, per…