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

Re: Postgres vr.s Oracle

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: "Brian Hurt" <bhurt(at)janestcapital(dot)com>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Postgres vr.s Oracle
Date: 2008-12-15 02:58:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-advocacy
On Sun, Dec 14, 2008 at 2:33 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> What tests are you running?  There are certainly things, performance-wise,
> which Oracle does better than us.  There are also things they do worse.

Various benchmarks.  So far I've fully performed DBT-2 and DBT-3.
I've also been toying with a couple of the OSS benchmarks, but I'm not
sure which I'd like to use.

> I'll point out that, the last time we had public comparables head-to-head,
> with *Oracle* doing Oracle's tuning on SpecJAppserver, PostgreSQL was around
> 90% of Oracle *10* on analogous hardware.  In internal tests at Sun I can't
> quote directly, that comparison held on succeeding generations of hardware I
> wasn't allowed to publish :-(

Sucks that you weren't able to publish them before leaving :(

> And I'd match the Sun performance labs' knowledge of Oracle tuning against
> yours any day.

Perhaps.  I don't know anyone on Sun's performance team, so I can't
speak to that directly.  Though, I do seem to recall going over the
Postgres configuration used on those benchmarks, and that it wasn't as
optimized as it could've been.

> Not, on TPC-E on the other hand, Oracle is way ahead of us ... we were like
> 50% last I checked, due mostly to the amount of time it takes us to resolve
> lock conflicts vs. Oracle.  Of course, Microsoft is beating Oracle by 50%,
> so Oracle is not the one to match on that benchmark.

Yeah, Microsoft is doing quite well at TPC-E.

Jonah H. Harris, Senior DBA

In response to

pgsql-advocacy by date

Next:From: Gregory StarkDate: 2008-12-15 03:13:51
Subject: Re: Postgres vr.s Oracle
Previous:From: Jonah H. HarrisDate: 2008-12-15 02:51:04
Subject: Re: Postgres vr.s Oracle

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