I helped several small business run web apps that use mysql without any issue. Only one of my customer asked for a Discourse installation that had postgres. Managing that database was a nightmare. The server would often crash for no reason, took seriously large diskspace etc. Unlike mysql I was not able to quickly understand the problems and handle them. I am pretty sure when configured properly etc. Postgres runs better than mysql but that extra trouble is not worth for most people.