Menu

Post image 1
Post image 2
1 / 2
0

We Switched from MySQL to PostgreSQL 17 and Improved Query Performance by 50%

DEV Community·ANKUSH CHOUDHARY JOHAL·about 1 month ago
#96rHJmtH
Reading 0:00
15s threshold

After 14 months of production traffic, 12 TB of relational data, and 47 million daily queries, our team cut p99 query latency by 52.3% by migrating from MySQL 8.0.36 to PostgreSQL 17.2. This isn't a hype piece: every claim here is backed by production benchmarks, reproducible test suites, and open-source migration tooling we've published to GitHub. 📡 Hacker News Top Stories Right Now Integrated by Design (66 points) Microsoft and OpenAI end their exclusive and revenue-sharing deal (758 points) Talkie: a 13B vintage language model from 1930 (90 points) Meetings are forcing functions (45 points) Three men are facing charges in Toronto SMS Blaster arrests (96 points) Key Insights PostgreSQL 17's native ICU collation support reduced sorting latency for multilingual user data by 68% compared to MySQL 8.0's default collation. We used pgloader 3.6.10 and a custom GitHub Actions pipeline ( https://github.com/our-org/pg-migration-toolkit ) to migrate 12 TB of data with zero downtime.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More