> What killer core features does Oracle have that Postgres doesn't?
While I don't really like Oracle as a company, there are some features that Oracle has and postgres don't, that can be important for production deployment:
- flashback
- partitioning that's much more mature
- merge /*+ parallel
- materialized views that refresh on commit
- and oracle is quite a bit quicker - especially with badly written queries
But those (except for optimizer) are all Oracle Enterprise features which means you're paying ridiculous money per-core for enterprise edition itself, and then you're paying ridiculous money for the features one by one.
There's mostly no reason to use Oracle Standard edition instead of postgres. And I have seen Oracle XE in producion and that's just sad.
EDIT: oh and I forgot - postgres has that stupid "we don't want to include optimization hints in the language so we use CTEs as optimization boundary" policy that the developers stuck on and refuse to change, which means you have to decide between readable code and performant code. Meh.