At 13:07 28/10/01 -0400, you wrote:
>I'm questioning whether anyone has done benchmarks on various hardware for
>PGSQL and MySQL. I'm either thinking dual P3-866's, Dual AMD-1200's, etc.
>I'm looking for benchmarks of large queries on striped -vs- non-striped
>volumes, different processor speeds, etc.
Hello Mike,
IMHO, you should consider *simple* software optimization first.
Hardware can bring a 2x gain whereas software optimization can boost an
application by 10x. Until now, I never heard or read about a real *software
optimization* benchmark between MySQL and PostgreSQL.
Software optimization includes the use of views, triggers, rules, PL/pgSQL
server side programming. By definition, it is hard to compare MySQL with
PostgreSQL because MySQL *does not include* these important features (and
probably will never do).
I see at least two easy cases where PostgreSQL beats MySQL:
1) Create a simple relational DB with triggers storing values instead of
performing LEFT JOINS. Increase the number of simultaneous queries. MySQL
will die at x queries and PostgreSQL will still be working at 5x queries.
2) Use PL/pgSQL to perform complex jobs normally devoted to an application
server (Java, PHP) on a separate platform. In some case (recursive loops
for example), network traffic can be divided by 100. As a result,
PostgreSQL can be 10x faster because everything is performed server-side.
This is to say that, in some circomstances, PostgreSQL running on an i586
with IDE drive beats MySQL on a double Pentium. In real life, applications
are always optimized at software level first before hardware level. This is
why PostsgreSQL is *by nature* better than MySQL.
Unless MySQL gets better, there is no real challenge in comparing both systems.
Cheers,
Jean-Michel POURE