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

Re: Benchmarks of MySQL, MaxDB, PostgreSQL, and Oracle

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "CN" <cnliou9(at)fastmail(dot)fm>
Cc: pgsql-benchmarks(at)postgresql(dot)org
Subject: Re: Benchmarks of MySQL, MaxDB, PostgreSQL, and Oracle
Date: 2005-03-24 15:26:07
Message-ID: 26823.1111677967@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-benchmarks
"CN" <cnliou9(at)fastmail(dot)fm> writes:
> A person compared the performances of MySQL, MaxDB, PostgreSQL, and
> Oracle, and posted his result at
> http://laser.dyndns.pgsqldb.com/index.php?rid=1923&S=aeac79693ab902121ccb13957fb65d8c&t=msg&th=5893&start=0&logoff=1

Ah, your good old basic MySQL-friendly benchmark design: let's test one
client doing one trivial query type over and over, so we can ignore all
those nasty concurrency issues.  Oh, and let's not say anything about
configuration, so no one can tell if the various DBs have been set up
reasonably.

Postgres would probably show up better on platforms other than Windows;
the native Windows port is brand new and hasn't been shaken out at all
as far as performance goes.  In particular, assuming that this was run
with the default fsync mode, it probably suffers badly from the fsync-
is-writethrough-on-Windows problem that was just recently fixed.

> Should we ignore all of them?

Pretty much.  Any "benchmark" testing only one query type, and as poorly
documented as this, is not really worth the trouble to respond to
anyway.

(If I could read Chinese maybe I'd not think it was so poorly
documented, but there surely isn't a lot of info on that page
about the test conditions.)

			regards, tom lane

In response to

pgsql-benchmarks by date

Next:From: Andre NasDate: 2005-05-15 09:37:07
Subject: Error when try installing pgbench ?
Previous:From: jeet mukherjeeDate: 2005-03-24 14:36:24
Subject: A new bie question

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