pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard_D_Levine@raytheon.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Does PostgreSQL run with Oracle?
Date: Fri, 15 Oct 2004 14:06:18 -0400
Message-ID: <11590.1097863578@sss.pgh.pa.us> (raw)
In-Reply-To: <OFFE95E8F5.016BABC9-ON05256F2E.005B907D@ftw.us.ray.com>
References: <OFFE95E8F5.016BABC9-ON05256F2E.005B907D@ftw.us.ray.com>

Richard_D_Levine@raytheon.com writes:
> My basic question to the community is "is PostgreSQL approximately as fast
> as Oracle?"

The anecdotal evidence I've seen leaves me with the impression that when
you first take an Oracle-based app and drop it into Postgres, it won't
perform particularly well, but with tuning and tweaking you can roughly
equal and often exceed the original performance.  The two DBs are enough
unalike that a database schema that's been tuned for Oracle is probably
mistuned for Postgres.  You will certainly find "some things are faster,
some are slower" at the end of the day, but we've had lots of satisfied
switchers ...

			regards, tom lane



view thread (8+ messages)  latest in thread

Message-ID: <11590.1097863578@sss.pgh.pa.us>
Permalink:  ../11590.1097863578@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/11590.1097863578@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Richard_D_Levine@raytheon.com
  Subject: Re: Does PostgreSQL run with Oracle?
  In-Reply-To: <11590.1097863578@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox