Re: [PHP3] Re: PostgreSQL vs Mysql comparison

On Sun, 3 Oct 1999, Paul DuBois wrote:

> >    Is that the benchmarks that are still based on v6.4.2? *raised
> >eyebrow*  We saw a significant performance increase when we moved from the
> >old 'table locking' to MVCC ...
> >
> >    Also, please note also that those benchmarks were/are based on
> >what MySQL is capable of, not what the other SQL servers are capable of.
> >For instance, if I take an SQL query that has been "optimized for MySQL"
> >and run it verbatim under PostgreSQL, the difference is a 2sec result for
> >MySQL vs 19sec for PostgreSQL ... if I re-write that query for
> >PostgreSQL's featuers (namely, using subselects), i can get the query down
> >to 1sec *shrug*
> >
> >    Would be interesting to see us (PostgreSQL) come up with
> >benchmarks against MySQL...we'd be able to put stuff like "couldn't
> >test under MySQL, since they don't support this SQL construct"...
>
>
> 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.

Amen. I am more interested in objective data than I am in database
religion. :-) If Postgres looks good on some benchmarks, let's see em.


--
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin@lists.php.net