Re:Oracle vs. PostgreSQL: First Glance
by thda on Wednesday May 06, 2020 @04:12AM
(#23088903)
I thought that by large datasets you meant TB of data that we see in analytics. And in this area clickhouse is growing and coming to the big companies I work for, one way or another.
postgresql handles the OLTP decently enough.
That leaves only niches for oracle.
[ Parent
| on HN ]
Re:Oracle vs. PostgreSQL: First Glance
by tomnipotent on Wednesday May 06, 2020 @11:31AM
(#23092118)
> I thought that by large datasets you meant TB
Oracle DB has no problems with TB-sized datasets, and if you have that kind of data you're probably not worried about Oracle-sized licenses.
> That leaves only niches for oracle.
Why do people keep beating this dead horse? Oracle DB is backing a non-trivial % of global GDP in a large number of Fortune 500's. It's not niche, it's just not a tool you use for hosting WordPress, Magento, and RoR apps.
> and if you have that kind of data you're probably not worried about Oracle-sized licenses.
We're a two-man startup selling analytics of blockchain data. We have a several-terabyte data set and basically no hosting budget. I don't think we're all that unusual. Dataset size does not imply organizational size/budget.