news.ycombinator.com• Apr 24, 2009• 1 min read
Ask HN: When to use MySQL vs PgSQL?Dear HN,first of all thank you that you are reading this. Out of caution, please let me remind you that I don't want you to take this question and to start a "flame war". Arguments with facts would really be constructive.I am sincerely interested if my current assumptions are true or where I am wrong.Background:My current employer asked me about MySQL and I mentioned those points below which were later countered with this:http://pastie.org/456941(Large) Parts of this gave me the classical "WTF" moment. So I thought I ask you about this.Detailed arguments against MySQL from my side:A long time ago I saw this nice PDF where there were some measurements between PgSQL and MySQL. http://people.freebsd.org/~kris/scaling/7.0%20and%20beyond.pdf Title: "FreeBSD 7.0 and Beyond" on Page 9 following there is a Case Study of MySQL vs. PgSQL.This was for me the first reason to really take a closer look at MySQL.Secondly I know that MySQL uses two different internal SQL engines. A X/Open XA distribut