Re: mysql-pgsql comparison

Peter Eisentraut wrote:
> 
> 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.

I used to have a pointer to the OSDB benchmark in their interactive
docs.  It would be very crappy of them to have removed it, as OSDB does
work for both MySQL and PostgreSQL.  :(

+ Justin

> 
> --
> Peter Eisentraut   peter_e@gmx.net
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."  - Indira Gandhi