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

Re: Not to start a flame war but what does Oracle have that Postgresql does not?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Not to start a flame war but what does Oracle have that Postgresql does not?
Date: 2011-03-23 15:35:53
Message-ID: imd40p$aof$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
LWATCDR, 23.03.2011 14:58:
> So I am wondering what features does Postgres lack to equal Oracle or
> DB2?  This is more for my own satisfaction since I can not imagine any
> uses here that wouldn't run on a modern hexcore server with a few
> gigabytes of ram and a raid of SATA drives.

Things that Oracle has that PostgreSQL does not:

- materialized views
- Flashback queries and flashback archive
- A lot more index types and table organization types - which are relevant in a DWH environment
- Much better partitioning (it's a lot easier and more flexible - including partitioning for indexes)
- real stored procedures (and the possibility to have transaction control in the stored procedure)
- Index only scans
- Better XML support
- I haven't used it, but the new "Edition" feature in 11gR2 seems
   to be very cool when dealing with schema migration
- A tool for an online redefinition of tables without the need to lock the table
   when doing the ALTER TABLE...
- Much more monitoring tools built-in
- no need to configure (auto) vacuum

Things that Postgres has that Oracle does not:

- transactional DDL (including TRUNCATE)
- can use more than one index for one table in one query
- multiple sessions sharing the same full table scan
- better support for arrays
- hstore module
- Possibility to define comments on every object in the database.
- a smaller footprint and easier to install
- generate_series()
- a slightly better support for windowing functions
- The sequence implementation in Postgres is better
   (due to the fact that a column can "own" a sequence, in Oracle there is
    no way to define a dependency between a column and a sequence)

I don't really know DB2, but as far as I can tell DB2's dictionary based compression and
its XML support are both a lot better than in Oracle or Postgres.


In response to


pgsql-novice by date

Next:From: Rob RichardsonDate: 2011-03-23 15:40:34
Subject: Re: Re: Not to start a flame war but what does Oracle have that Postgresql does not?
Previous:From: Bill P.Date: 2011-03-23 15:16:55
Subject: EnterpriseDB OSX 9.0.2 PostgresPlus Installer

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