At my last job, I ran about 50 servers running Oracle Standard Edition. (Enterprise Edition would have taken each $25k license to something like $600k for our dual core servers). I was Sysadmin, not a developer, so I have different pain points.
I will never look back. There were so many things that we wanted to do, but were 'enterprise only' features. Like rebuild/create indexes online. We had a DB with a 1TB table. rebuilding that, while locking the table, would mean something like a 14 hour outage. With postgresql, online index creation is right there.
Oracle didn't support a proper incremental backup, except in enterprise edition. (and RMAN was a pain in the ass of arcane commands and black magic). pgBarman makes backups so simple for us.
Standby's on Oracle are good for disaster recovery. But you have to manually ship the logs, apply them, monitor it, and delete old logs. There were multiple thousand line korn shell scripts we utilized, and lots of cronjobs. With Postgresql, its stream based, and my standby follows production by less than 100ms most of the time. Plus, I can connect to the standby, and run read-only queries on it (we run large reports on standby, so we don't affect production) That is also possible in Oracle, with 'enterprise' edition (data-gaurd).
We filed a few ticket with Oracle Support. We never got any answers. I don't think we ever got an support person at Oracle that had been there more than a year. Even when we escalated.
Pretty easy to find "support" for Postgres too and more convenient. e.g. submit a request on CodeMentor and you'll have you several solid devs willing to help you, live, in a matter of minutes.
Well, there's the old IBM adage, adapted: nobody has ever gotten fired for choosing oracle. And within some industries that might be true.
Anecdotally, I've met someone who said his interview with a startup went completely downhill when he suggested using oracle. Can't say I blame a startup for shutting down that idea immediately.
I will never look back. There were so many things that we wanted to do, but were 'enterprise only' features. Like rebuild/create indexes online. We had a DB with a 1TB table. rebuilding that, while locking the table, would mean something like a 14 hour outage. With postgresql, online index creation is right there.
Oracle didn't support a proper incremental backup, except in enterprise edition. (and RMAN was a pain in the ass of arcane commands and black magic). pgBarman makes backups so simple for us.
Standby's on Oracle are good for disaster recovery. But you have to manually ship the logs, apply them, monitor it, and delete old logs. There were multiple thousand line korn shell scripts we utilized, and lots of cronjobs. With Postgresql, its stream based, and my standby follows production by less than 100ms most of the time. Plus, I can connect to the standby, and run read-only queries on it (we run large reports on standby, so we don't affect production) That is also possible in Oracle, with 'enterprise' edition (data-gaurd).
We filed a few ticket with Oracle Support. We never got any answers. I don't think we ever got an support person at Oracle that had been there more than a year. Even when we escalated.