Why should we use postgresql or mysql, and which version ?

Which one would be better to use on long term ? Depending on caching, stored procedures, relations, data storing (ease of partitioning), backup & restore issues.

Assume that there is enough processing power and ram.

thanks for answers