3 ms·
> MySQL was known for fast and Postgres for features and correctness That's still the case. In particular, MySQL is faster for updates (no MVCC), but that com
by paulddraper 3y ago
> MySQL was known for fast and Postgres for features and correctness
That's still the case.
In particular, MySQL is faster for updates (no MVCC), but that comes at a cost that I would be hesitant to pay.
- evanelias 3y agoInnoDB (MySQL's default storage engine since 2010) has always used MVCC. Its MVCC implementation is arguably better than Postgres's in some important ways, see e.g. https://ottertune.com/blog/the-part-of-postgresql-we-hate-the-most/ https://ottertune.com/blog/the-part-of-postgresql-we-hate-th...