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

Re: Benchmark comparing PostgreSQL, MySQL and Oracle

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Cc: Sergio Lopez <sergio(dot)lopez(at)nologin(dot)es>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle
Date: 2009-02-20 19:35:39
Message-ID: 603c8f070902201135q5777dc7y541075de7251ac87@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> First of all, you need to do some research on the benchmark kit itself,
> rather than blindly downloading and using one.  BenchmarkSQL has significant
> bugs in it which affect the result.  I can say that authoritatively as I
> worked on/with it for quite awhile.  Don't trust any result that comes from
> BenchmarkSQL.  If you fix the bugs, Oracle (out of the box in OLTP config)
> will come out 60%.

60% what?

> Oracle comes out twice as fast as PG on Linux.  And, unless you're using a
> significant number of warehouses, MySQL+InnoDB will come out better than PG
> as well.

I can believe that MySQL could come out faster than PG because I've
had previous experience with it being blindingly fast.  Of course I've
also had experience with it having amazingly poor data integrity.  I
would be pretty surprised if Oracle were in general twice as fast as
PG - what are they doing that much better than what we're doing?  I
could certainly imagine it being true in cases that rely on specific
features we lack (e.g. join removal)?

...Robert

In response to

Responses

pgsql-performance by date

Next:From: Jonah H. HarrisDate: 2009-02-20 19:48:06
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle
Previous:From: Sergio LopezDate: 2009-02-20 18:15:01
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle

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