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