From: Date: October 4 1999 7:38pm Subject: Re: [PHP3] Re: PostgreSQL vs Mysql comparison List-Archive: http://lists.mysql.com/mysql/15094 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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.