MySQL can work wonders for simple and large databases but once you try and throw complex queries at it, this where the power of Postgres will make MySQL look like a toy. I would always recommend Postgres over MySQL if you have a choice, it just scales so much better.