|From:||Thomas Kellerer <shammat(at)gmx(dot)net>|
|Subject:||Re: Oracle vs. PostgreSQL - a comment|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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
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%.
|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|