All enterprise level RDMS have similar capabilities, some of which are yet to come to Postgres.
Postgres essentially made every other RDMS obsolete except for some niche circumstantial cases (e.g. vendor lock-in)
> enterprise level
Postgres is enterprise level (whatever that means). Blazingly fast, Web 3, cloud-native, etc etc, pick your own buzzwords
Usually, it is a great way for many organizations to have a database as free beer.
And for the other 1%, it sometimes happens that their need for a specific feature in Oracle DB turns out to be entirely unnecessary.
Not to mention that the vast majority of products turn out to be fancy CRUD apps. Doesn't matter though, Oracle will convince you that you NEED their DB regardless.
But don’t get me wrong. Postgres is an awesome database system.
They have multiple tiers of support as well, pretty interesting read
Because I suspect it does not mean what I think you think it means.
(Typically the EULA of all those non-Postgres systems are 'this is sold as is, no warranty as to suitability to your purpose, yada yada'
Often times people believe that if they're paying many monies for a support contract, that means they can relocate their liability to that company. Almost every time, that company has better lawyers / contract writers.
Potsgres is the one general purpose DBMS out there that you can hire a company to actually solve your problems.
And on the very uncommon cases that you need really something that Postgres doesn't do, Oracle, MS SQL, DB2, and co do not provide enough of a difference, and what you actually need is an specialized DBMS.
I've got software to write, I don't want to find out that script I copied from stackoverflow to backup the database doesn't work in all the scenarios I thought it would because something changed a minor version ago.
it has issues in several choke points: HA setup is complicated, it doesn't utilize multi-core machines well on heavy queries.
It means "non-technical executives/managers recognize the name and will approve its use". Like Oracle.
Performance monitoring is pretty much absent, all you have is pg_stat_statements and friends. So for any serious scale you need 3d party solution (or you're writing your own) straight away.
HA is complicated. Patroni is the best option now, but it's quite far from experience SQL Server or Oracle provide.
Optimizer is still quite a bit simpler than in SQL server/Oracle. One big thing that is missing for me is "adaptive" query processing (there's AQP extension, but it's not a part of distribution). Even basic adaptive features help a lot when optimizer is doing stupid things (I'm not gonna bring up query hints here :))