Skip site navigation (1) Skip section navigation (2)

Re: Ultimate DB Server

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Mike Rogers <temp6453(at)hotmail(dot)com>
Subject: Re: Ultimate DB Server
Date: 2001-10-28 19:18:41
Message-ID: 4.2.0.58.20011028194736.00a23670@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
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


In response to

Responses

pgsql-hackers by date

Next:From: mlwDate: 2001-10-28 22:19:28
Subject: Re: Ultimate DB Server
Previous:From: Peter EisentrautDate: 2001-10-28 19:16:05
Subject: Re: [patch] helps fe-connect.c handle -EINTR more gracefully

pgsql-admin by date

Next:From: mlwDate: 2001-10-28 22:19:28
Subject: Re: Ultimate DB Server
Previous:From: Patrice HédéDate: 2001-10-28 18:03:05
Subject: Re: UNICODE

pgsql-general by date

Next:From: mlwDate: 2001-10-28 22:19:28
Subject: Re: Ultimate DB Server
Previous:From: Patrice HédéDate: 2001-10-28 18:03:05
Subject: Re: UNICODE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group