On 7/2/07, Matt W. email@example.com wrote:
My company is currently using Rails with PostgreSQL. We have lots of
performance issues and some of the developers/admins think that
switching to MySQL will solve at least some of the problems since so
many Rails enthusiasts use MySQL.
From my own research on the issue, I
have not seen that MySQL is consistently better than PostgreSQL at
anything really. I have noticed that PostgreSQL seems to outperform
MySQL significantly given multiple cores. Can anyone share with me an
educated opinion on the matter or point me to some resources where I
can find more information? Thanks!
I agree with what Philip said, define the problem first. In my
experience postgresql holds up better under load, and much better with
complicated queries that contain lots of subselects, aggregates, etc…
But postgresql has to be tuned. It gives you a superior query
planner and better/more reliable statistics for tuning, but you have
to do it.
The postgresql lists are great, you should really ask your question
there, but be prepared to give a lot more information such as an
explain analyze for the queries that are slow, etc…