3 ms·
How does MySQL compare? I get the sense that innovations land there sooner because of all the mega corps that use it.
by paulryanrogers 2y ago
How does MySQL compare? I get the sense that innovations land there sooner because of all the mega corps that use it.
- re-thc 2y agoA lot of the work is now part of MySQL Heatwave, the paid Oracle / cloud edition.
- sgarland 2y agoMySQL hasn’t had nearly as many innovations. That said, for a long time, it was often faster for simpler queries, and especially range queries, IFF your schema was designed to exploit the fact that it’s a clustering index, so rows are physically located next to the PK. If you’re using UUIDv4 PKs, you’re throwing away its entire advantage, and Postgres will almost certainly be faster. One notable exception for MySQL is INSTANT DDL in 8.x, thanks to contributions from Tencent, which is an extremely nice QoL upgrade that Postgres doesn’t have. The other is logical replication, something Postgres does support now (and has for several years), but didn’t for a long time.