3 ms·
What killer core features does Oracle have that Postgres doesn't? Lots of third party applications that support Oracle and not Postgres is sadly the most commo
by dagw 11y ago
What killer core features does Oracle have that Postgres doesn't?
Lots of third party applications that support Oracle and not Postgres is sadly the most common reason I see people deploying Oracle these days. Also Oracle used to be a lot better with larger databases (400+ TB or so), but I have no idea if that is still true.
- jerven 11y agoUnfortunately yes, the compression options and existing parallel code in Oracle means that at the moment IMHO Oracle performs better than PG at that scale. There are multi petabyte Oracle RAC instances in existence, while on the other hand a 10TB+ PG is very large. This is a first step in closing that gap. Some form of compression on block level would really help as well. For analytics columnar support will be needed to, and an in-memory option would be nice too.