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(at)gmx(dot)net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)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