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

Re: Does PostgreSQL run with Oracle?

From: Mike Rylander <mrylander(at)gmail(dot)com>
To: "richard_d_levine(at)raytheon(dot)com" <richard_d_levine(at)raytheon(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Does PostgreSQL run with Oracle?
Date: 2004-10-15 19:45:11
Message-ID: b918cf3d041015124550a51bd4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, 15 Oct 2004 11:54:44 -0500, richard_d_levine(at)raytheon(dot)com
<richard_d_levine(at)raytheon(dot)com> wrote:
> My basic question to the community is "is PostgreSQL approximately as fast
> as Oracle?"

My personal experience comparing PG to Oracle is across platforms,
Oracle on Sun/Solaris (2.7, quad-proc R440) and PG on Intel/Linux (2.6
kernel, dual P3/1GHz).  When both were tuned for the specific app I
saw a 45% speedup after switching to PG.  This was with a customized
CRM and System Monitoring application serving ~40,000 trouble tickets
and monitoring 5,000 metric datapoints every 5-30 minutes.

The hardware was definitely not comparable (the Intel boxes have more
horsepower and faster disks), but dollar for dollar, including support
costs, PG is the winner by a BIG margin.  YMMV, of course, and my
results are apparently above average.

Another big plus I found was that PG is much easier to admin as long
as you turn on pg_autovacuum.

--miker

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-10-15 19:53:28
Subject: Re: Tuning shared_buffers with ipcs ?
Previous:From: Josh BerkusDate: 2004-10-15 19:44:52
Subject: Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...

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