MySQL always sucked ass.

PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast.

Postgres has/had the best SQL standard support out of every server, open-source or not.

MySQL was at the other end, only started catching up after Oracle bought it.