Re: mysql-pgsql comparison - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: mysql-pgsql comparison
Date
Msg-id Pine.LNX.4.30.0201131143480.725-100000@peter.localdomain
Whole thread Raw
In response to mysql-pgsql comparison  (Michael Meskes <meskes@postgresql.org>)
Responses Re: mysql-pgsql comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: mysql-pgsql comparison  (Michael Meskes <meskes@postgresql.org>)
List pgsql-hackers
Michael Meskes writes:

> I just read one of those MySQL-PGSQL comparison on a German Linux magazine
> that's not exactly known to be well informed. :-)

I think the article you're speaking of is here:

http://www.linuxenterprise.de/artikel/my_sql.pdf

The last part of this, which is the supposed comparison, was pretty much
copied straight out of their manual.  I have a response to that here:

http://www.ca.postgresql.org/~petere/comparison.html

However, if you don't look hard enough, it's actually true that the only
benchmark that runs on both systems is the MySQL benchmark.  I think the
OSDB benchmark should also work, though.

What we could do is:

1. Actually run the MySQL benchmark, to see what's wrong with it.  (Note
that this is not the crashme test.)

2. Port pgbench to MySQL.  Pgbench seems to be our daily benchmark of
choice, so it's not unimportant to verify how it does elsewhere.

3. Check out the OSDB benchmark more closely.

I think I should also submit my article to their interactive docs, so that
those that do comparisons in the future by just reading the manual will
get a clue.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem reloading regression database
Next
From: Tom Lane
Date:
Subject: Re: mysql-pgsql comparison