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
