When should one switch from MySQL to Oracle or PostgreSQL?
12th October 2010
My answer to When should one switch from MySQL to Oracle or PostgreSQL? on Quora
When your own benchmarks prove that your application’s particular load characteristics will perform better on another database—and the difference is large enough that it’s worth the cost involved in retargeting your code. If that cost is high (and it probably will be) it may be worth paying for some expert consultants to ensure that your implementations against the different databases are properly optimised.
External benchmarks and reports for products as similar as these will rarely teach you anything useful about your own particular situation.
More recent articles
- Introducing gisthost.github.io - 1st January 2026
- 2025: The year in LLMs - 31st December 2025
- How Rob Pike got spammed with an AI slop "act of kindness" - 26th December 2025