3 ms·
Unfortunately yes, the compression options and existing parallel code in Oracle means that at the moment IMHO Oracle performs better than PG at that scale. The
by jerven 11y ago
Unfortunately 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.