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

Re: Benchmark comparing PostgreSQL, MySQL and Oracle

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: Sergio Lopez <sergio(dot)lopez(at)nologin(dot)es>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle
Date: 2009-02-20 19:55:05
Message-ID: 36e682920902201155p4e447505t58b4f0e8848f7ffe@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Feb 20, 2009 at 2:48 PM, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com>wrote:

> Having this said, the benchmark is not as unfair as you thought. I've
>> taken care to prepare all databases to meet similar values for their
>> cache, buffers and I/O configuration (to what's possible given their
>> differences), and the I've left the rest as comes by default (for
>> Oracle I've used the OLTP template).
>
>
> Oracle's buffer cache is different than Postgres'.  And there are several
> other tuning paramaters which control how the buffer cache and I/O between
> cache and disk is performed.  Making them the same size means nothing.  And,
> as I said, you still didn't mention other important tuning parameters in
> MySQL, Postgres, or Oracle.  So either you don't know about them, or you
> didn't bother to tune them, which is odd if you were trying to run a truly
> comparative benchmark.
>

Also forgot to ask, what block size did you use in Oracle?  You mentioned
tuning the shared pool, but you didn't specify db_cache_size or whether you
were using automatic SGA tuning.  Were those not tuned?

-- 
Jonah H. Harris, Senior DBA
myYearbook.com

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2009-02-20 20:40:16
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle
Previous:From: Jonah H. HarrisDate: 2009-02-20 19:51:53
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle

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