5 ms·

Just curious, for what reasons would you choose MySQL over Postgres?

• kenhwang 6y ago
  Personally, when I want speed or easy upkeep and intend on doing dumb simple things. Postgres is more featureful, but if you don't intend on using those features, MySQL is consistently faster and historically smoother to update and keep running.
  • busterarm 6y ago
    Also in the Enterprise, if you're doing a lot of sharding and replication across networks, Percona MySQL is a very compelling product. I say that as a Postgres diehard.
  • twic 6y ago
    > MySQL is consistently faster Unless you want to do a join.
• malinens 6y ago
  Probably the same way sometimes people choose sqlite versus mysql- simplicity. There are many cons and pros for both of them!
• xorcist 6y ago
  Traditionally it was because you needed replication or sharding that you didn't have to boil half an ocean for, or at least half decent full text indices. These days however I believe the differences are smaller and in other areas. Most often, you choose a database because of what you application supports and is tested with, not the other way around. Or what your other applications already use. Complete green fields aren't all that common.
• Shorel 6y ago
  Replication. And our DBAs are already familiar with the gotchas of MySQL. You just have to write queries in a different way (subqueries are slow, so they are to be rewritten as joins).