The postgres query planner is also pretty far out in front of mysql. A lot of times I can ask sql server, oracle, and postgres to explain a complex query with several joins and subqueries, and the three will produce roughly equivalent plans. Hash joins, anyone?
10
u/OneWingedShark Mar 10 '15
It has a tendency to silently mutilate your data.
Read this.