4 ms·

I have tried to search for MySQL vs. PostgreSQL benchmarks and most of them date to 2007. Are there any recent benchmarks that compare these databases? I perso

by amix 18y ago

I have tried to search for MySQL vs. PostgreSQL benchmarks and most of them date to 2007. Are there any recent benchmarks that compare these databases? I personally use MySQL and I think it's an OK database (performance and installation wise) and I think it's a bit risky to jump on PostgreSQL when most others use MySQL (e.g. Flickr, Facebook, Yahoo, Google just to name a few).

newt0311 18y ago
Benchmarks between DBs are pretty rare because they are so difficult to control for. The configurations make a big difference. One set of benchmarks is here: http://tweakers.net/reviews/657/6 http://tweakers.net/reviews/657/6 but thats in 2006. Also, MySQL has known fatal bugs in the production release so mysql isn't exactly a safe choice.
- staunch 18y ago
  > Also, MySQL has known fatal bugs in the production release so mysql isn't exactly a safe choice. Outright FUD.
  - newt0311 18y ago
    Not quite: MySQL GA release with known crashing bugs: http://news.ycombinator.com/item?id=380092 http://news.ycombinator.com/item?id=380092 Comparison of MySQL and PostgreSQL releases: http://news.ycombinator.com/item?id=381899 http://news.ycombinator.com/item?id=381899
ocskills 18y ago
Of note, Sun ironically performed a benchmark between PostgreSQL and Oracle. The results were that PostgreSQL performed very closely to Oracle under several scenarios. http://it.toolbox.com/blogs/database-soup/postgresql-publishes-first-real-benchmark-17470 http://it.toolbox.com/blogs/database-soup/postgresql-publish... It's not a direct comparison between MySQL, but Oracle is highly regarded from a performance standpoint.