Skip site navigation (1) Skip section navigation (2)

Re: MySQL+InnoDB vs. PostgreSQL test?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: MySQL+InnoDB vs. PostgreSQL test?
Date: 2004-02-03 16:19:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-advocacypgsql-performance
Christopher Browne wrote:

>In an attempt to throw the authorities off his trail, JanWieck(at)Yahoo(dot)com (Jan Wieck) transmitted:
>>Josh Berkus wrote:
>>>I've had requests from a couple of businesses to see results of
>>>infomal MySQL
>>>+InnoDB vs. PostgreSQL tests.    I know that we don't have the setup
>>>to do full formal benchmarking, but surely someone in our community
>>>has gone head-to-head on your own application?
>>how does someone compare an Apache+PHP+MySQL "thing" against something
>>implemented with half the stuff done in stored procedures and the
>>entire business model guarded by referential integrity, custom
>>triggers and whatnot?
>>Seriously, I am tired of this kind of question. You gotta get bold
>>enough to stand up in a "meeting" like that, say "guy's, you can ask
>>me how this compares to Oracle ... but if you're seriously asking me
>>how this compares to MySQL, call me again when you've done your
>Actually, before saying anything in public about their products, check
>out what they require for use of their protected trademarks.
>To wit, they indicate that:
>  "The MySQL AB Marks may not be used in a manner or with respect to
>  products that will decrease the value of the MySQL AB Marks or
>  otherwise impair or damage MySQL AB's brand integrity, reputation or
>  goodwill"
>It seems to me that presenting a benchmark that did not favor their
>product could be quite reasonably considered to be an "impairment" of
>their integrity, reputation, or goodwill, and therefore be something
>worthy of legal attack.
It depends on how it is presented. Basically you just don't offer an 
opinion on the matter.
For example...

MySQL was 10x slower than PostgreSQL in this test....

Instead you could use something like.

We performed the following test.

MySQL scored this much
PostgreSQL scored this much

Notice no use of explaination.....


Joshua D. Drake

Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com -
PostgreSQL Replicator -- production quality replication for PostgreSQL

In response to


pgsql-performance by date

Next:From: Kevin CarpenterDate: 2004-02-03 16:42:59
Subject: Database conversion woes...
Previous:From: JeffDate: 2004-02-03 15:53:49
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?

pgsql-advocacy by date

Next:From: Bruce MomjianDate: 2004-02-03 16:25:05
Subject: Re: Only SEVEN DAYS Until OSCON Deadline!
Previous:From: JeffDate: 2004-02-03 15:53:49
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group