Submission + - MySQL vs PostgreSQL benchmarks
spatialguy writes: Tweakers is a dutch community of online tweakers that are deciding on new hardware for their website and databases.
The link http://tweakers.net/reviews/674/7 [tweakers.net] leads you to some stunning performance graphs on a 8-way opteron system.
It shows that not only postgresql 8.2 is faster then MySQL 5.0, it also scales much better on heavy loads.
The tweakers community are longterm MySQL users and were new to PostgreSQL. However they even brought in a MySQL/Solaris expert to configure it optimally.
Still PostgreSQL turned out to be the better dbms under heavy loads.
They are very thorough in their tests, are themselves MySQL users, and give insight in which optimizations they used to perform these tests.
Interesting is that they discovered a small issue in the stable release of postgresql 8.2 which was subsequently patched by the postgresql developers.
The version pg 8.2.1 did ship with these patches.
They also revealed issues with Solaris, which were investigated by Sun developers, who helped in configuring the Solaris installation.
This second link http://tweakers.net/search?DB=Reviews&item_catId=1 2&productCatId=&Query=postgresql&x=0&y=0
will give you a search results page with links to many similar benchmarks on different architectures of MySQL vs PostgreSQL on their site.
All in all a very convincing read.
The link http://tweakers.net/reviews/674/7 [tweakers.net] leads you to some stunning performance graphs on a 8-way opteron system.
It shows that not only postgresql 8.2 is faster then MySQL 5.0, it also scales much better on heavy loads.
The tweakers community are longterm MySQL users and were new to PostgreSQL. However they even brought in a MySQL/Solaris expert to configure it optimally.
Still PostgreSQL turned out to be the better dbms under heavy loads.
They are very thorough in their tests, are themselves MySQL users, and give insight in which optimizations they used to perform these tests.
Interesting is that they discovered a small issue in the stable release of postgresql 8.2 which was subsequently patched by the postgresql developers.
The version pg 8.2.1 did ship with these patches.
They also revealed issues with Solaris, which were investigated by Sun developers, who helped in configuring the Solaris installation.
This second link http://tweakers.net/search?DB=Reviews&item_catId=
will give you a search results page with links to many similar benchmarks on different architectures of MySQL vs PostgreSQL on their site.
All in all a very convincing read.