Re: mysql-pgsql comparison

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(at)gmx(dot)net