5 ms·
Postgres is going in one direction - for the better. And as a long time Postgres user I've been really happy with it for years. Now with JSONB support I am even
by sgt 11y ago
Postgres is going in one direction - for the better. And as a long time Postgres user I've been really happy with it for years. Now with JSONB support I am even happier, as I can build powerful RDBMS + "NoSQL" apps that outperform traditional NoSQL databases.
To my disappointment several members of my team have been championing Oracle recently though - presumably because it's a safer option and can be managed by others under an SLA.
How does one argue against this? With Postgres we're not going to get SLA's because we know it very well, but with Oracle we would. It's mostly perception management IMHO, and I'm mostly against it. What killer core features does Oracle have that Postgres doesn't?
- jimmytucson 11y agoWell, parallel execution, for one. Am I reading this right? Postgres has not had parallel query, DML, or DDL until now? This has been a feature of Oracle for as long as I've been using it. Say what you want about enterprise software but Oracle is a beast... if you work for a company willing to shell out for it. That cost will seem sillier though Postgres closes the feature gap.
- dragonwriter 11y agoWell, professional support with SLAs of available for postgres through, most notably, EnterpriseDB, who also is a significant source of resources for core postgres development. So whether or not that's really something you need, that it is available for Oracle isn't a distinguishing point when compared with Postgres.
- LoSboccacc 11y agoAmazon RDB - not exactly the same as a managed oracle, but you get much in the package: backups, transparent multizone failover are the one that I prize the most.
- sciurus 11y agoI think you mean RDS, which is available for postgresql or Oracle.
- dikaiosune 11y agoAlthough notably the Oracle version along with MySQL has some features on RDS which PostgreSQL does not (like a HIPAA business partner agreement available for example).
- quizotic 11y agoOracle has tons of "features" that postgres lacks: * empty string == NULL in oracle * ROWNUM: it's kinda like a limit, but not * DUAL: hah. postgres eat your heart out. And of course there are business practice differences: http://www.businessinsider.com.au/oracle-customer-explains-audit-threats-2015-9 http://www.businessinsider.com.au/oracle-customer-explains-a... ... but tongue out of cheek, if you can afford it, Oracle has solutions for just about every database problem in just about every vertical domain. They have really good engineers, really good testing, and they're #1 for a reason
- je42 11y agoAnother one. DDL changes are not transactional.
- CaptainZapp 11y ago* empty string == NULL in oracle Why would that be a feature? NULL, by definition is neither 0 [zero], nor an empty string. NULL is an undefined value (sort of like a division by 0) Personally I'd see this as a bug, not as a feature. But your mileage may vary.
- jerven 11y agoYou missed the sarcasm quotes around the "feature" in the grandparent post.
- ldrndll 11y agoI think all those "features" are considered misfeatures by parent, and that he was being sarcastic.
- bsg75 11y agoUgh: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5984520277372 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUE... I am not sure if I am more or less confused. +1 for PostgreSQL on this one.
- lobster_johnson 11y ago
- rodgerd 11y ago> can be managed by others under an SLA. EnterpriseDB, Fujitsu, and others. > presumably because it's a safer option Spoken like people who have never dealt with Oracle licensing and compliance. "Safer" for values of "well, I guess we didn't need those millions in this year's budget anyway.
- glogla 11y ago> 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.
- pmontra 11y agoI didn't know about the CTE optimization fence. I was starting to use CTEs but I'll have to work around them. Thank you.
- sgt 11y agoFlashback is indeed a killer feature. I'd like to see something like Flashback in Postgres. PITR is possible with Postgres but it takes very long to replay log files to a certain point, if you need to restore data. I know this because I've had to do this quite a few times.
- je42 11y agoFlashback is useless if there are schema changes.
- jeltz 11y agoThere has been talk about removing the optimization fence but people are afraid of breaking people's applications.
- 11y ago
- dagw 11y agoWhat 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.
- technion 11y agoThe answer would likely be to just price up Oracle. Not just buying it, but over three years or whatever. Particularly if you virtualise, and get stuck by the varying definitions of what that means for core licensing. That might help you out. As for "killer features", the zero downtime version upgrades has always meant a lot to me.
- feld 11y agoIt will be cheaper to hire s Postgres developer than pay Oracle licensing
- brianwawok 11y ago*oracle licensing for one modern 32 core server
- meshko 11y agoMain problem with Oracle is cost. They are changing the licensing structure for the standard edition which is going to have some major impact on our business. Enterprise edition's price is completely prohibitive even for a large company. Most of the nice Oracle things require Enterprise. For example, RAC (clustering) actually works and is not bad, but to be useful you need Enterprise. The other thing that is pretty awesome is Enterprise Manager -- the web tool which lets you monitor your RAC, including looking at the executing queries, their plan and progress they are making. It is completely invaluable in diagnosing and improving slow queries. And it is, again, Enterprise only.
- jeffdavis 11y agoSend them to postgresql conferences. I'm serious. They will come back after speaking with people at very large banks (if they go to PgConf NY), very large insurance companies, and very large enterprise tech companies. All of them are moving more of their business into postgresql. Many of them are moving away from oracle. They will change their perception very quickly.