MySQL is faster.. ok, that-s all. we have a winner! thanks. Why MySQL instead of PostgreSQL.
Carlos Devia | Homepage | 08.15.07 - 1:20 am | #

So, in your opinion, speed is the only consideration? Nothing about data integrity? How about TCO in maintenance? How about advanced functionality?

I think speed is important but not at the cost of integrity.

LewisC
LewisC | Homepage | 08.15.07 - 10:10 am | #

I've written up a pretty up-to-date comparison between MySQL and PostgreSQL at WikiVS
and the page is editable by anyone.

So, if you want to contribute what you know, feel free to add your input!
David Lee | Homepage | 02.04.08 - 1:44 am | #

Thanks David. I'll take a look and post a link.

LewisC
LewisC | Homepage | 02.04.08 - 9:26 am | #

lol at Carlos, currently i use only Oracle becasue of my job, but just reading that silly comment about "we have a winner coz of speed" tells a lot about what kind of developer/dba you are LOL
arana | 09.24.08 - 8:13 pm | #

I can't decide on which one to use, MySQL or PostgreSQL. I read the wikivs page (btw, great job David, thanks) and I am still in a big dilemma about speed vs. reliability. And speaking of speed, I need the speed of MySQL, but, will I have that speed also on joins? I read in other articles that MySQL doesn't do well with joins, but there were no examples of which kinds of joins might be slow.
Hybris | Homepage | 11.12.08 - 4:05 am | #

It really depends on how you use the features of either server and how you design the database. Sometimes a connection pool/persistent connection helps a lot, sometimes a stored procedure helps too. If you have a small project you can try both MySQL and PostgreSQL and see which one is better for you.
Masha | Homepage | 12.04.08 - 10:22 pm | #