4 ms·
Uber once chose to switch from postgres to mysql, for performance reasons. There was a lot of debate and discussion on HN[0] about it. I think there is enou
by WatchDog 5y ago
Uber once chose to switch from postgres to mysql, for performance reasons.
There was a lot of debate and discussion on HN[0] about it. I think there is enough complexity in either system, that you can't make generalizations that a given system can "can handle more data and load".
[0]: https://news.ycombinator.com/item?id=26283348 https://news.ycombinator.com/item?id=26283348
- redis_mlc 5y agoThe reason was Postgres' write amplification issue, though I've read that has improved recently. Before a MySQL Innodb table could handle 20 indexes while Postgres around 5 with similar performance on updates.