Re: [PHP3] Re: PostgreSQL vs Mysql comparison

On Sun, 3 Oct 1999, Paul DuBois wrote:

> Well ... why don't you do that? While you're at it, if you can supply
> more recent benchmarks for Postgres to the MySQL people, I doubt if they'd
> refuse them. The benchmark page is meant to be helpful, not misleading
> or a propaganda tool for MySQL.

Actually, if you go through the PostgreSQL archives, there was *at least*
one major attempt at getting the MySQL benchmark page upgraded...the
thread involved the MySQL guys, and several of ours, and went on for a few
days...if I recall it all correctly...

...end result...no changes :(

The problem, as I see it, is how can you do a fair comparison when those
features we'd use to improve performance, subselects to name one, aren't
available in MySQL?

What I'd love to see is a common set of data to work from, and table
structures...then come up with, again, a common set of "results expected",
from the database. Then, let the MySQL guys provide their query for the
results, and let the PostgreSQL guys come up with theirs, and compare
*that*. Don't compare how to get the results the fastest through MySQL,
and then how the same query stands up under PostgreSQL...let us give them
how to get it fastest from PostgreSQL...

The problem also comes down to common hardware...

Anyone out there running a machine, and have the time, to do something
like this?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org