Re: Oracle vs. PostgreSQL - a comment

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Oracle vs. PostgreSQL - a comment
Date: 2020-06-01 07:53:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Stefan Knecht schrieb am 01.06.2020 um 07:36:
> Oracle is also the single most feature-rich database out there - the
> feature set of Postgres isn't even 1% of what Oracle has.

I try to stay out of discussions like this, but the above is simply
not true.

Oracle indeed has more features but 1% is by far not correct.
Monitoring and analyzing performance problems (using AWR, ASH) are one point,
rolling upgrade without downtime are another one.

I'd say it's more in the vicinity of 80% or 90% depending on which features
you find more important would be more realistic.

But then Postgres has features that Oracle has not, like
transactional DDL, a much richer set of data types (Oracle still
has no proper DATE or BOOLEAN type) and I think the extension system
is something that Oracle lacks as well (at least I am not aware
of any API that would let self-written code e.g. influence the
query optimizer). Postgres also has a more flexible indexing infrastructure
and it's full text search is much more stable and reliable.

So bottom line is - as far as I see it: you can't really come up with a percentage.

From a DBA point of view, the percentage is probably lower than 80%, from
a developer's point of view, Oracle lacks a lot of things and the percentage
would be greater than 100%.

My €0.02

In response to


Browse pgsql-general by date

  From Date Subject
Next Message Bernhard Beroun 2020-06-01 08:02:12 Vanishing unique constraint
Previous Message Paul Förster 2020-06-01 07:50:37 Re: Oracle vs. PostgreSQL - a comment