3 ms·
MySQL has undo logs while PostgreSQL has vacuum based MVCC. It's a significant difference for some workloads. And MySQL is closer to standard SQL on some things
by paulryanrogers 5y ago
MySQL has undo logs while PostgreSQL has vacuum based MVCC. It's a significant difference for some workloads. And MySQL is closer to standard SQL on some things like PL/PSM.
I personally still prefer PostgreSQL but can't deny the benefits of a well configured MySQL installation.