Oracle vs. PostgreSQL: First Glance

Re:Oracle vs. PostgreSQL: First Glance by ashtonkem on Monday May 04, 2020 @09:04AM (#23067507)

This is actually my experience with Oracle; I had a DBA to take the management pain from us, and we had the budget for the correct licenses and hardware. The query performance was phenomenal considering the absolutely crazy amount of data we threw at that thing.

That being said, I would not recommend Oracle without all of the above factors already in place. For most use cases, Oracle is more pain than it’s worth.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by AmericanChopper on Monday May 04, 2020 @09:31PM (#23075428)

As somebody who does a fair amount of DBA work, Oracle is my favorite RDBMS to operate. Low level administration is easy to manage, the optimizer is very performant, and the plan management features make tuning easy, and statistics management much less risky (and it can be very risky).

I wouldn't use it on any of my own projects though, but only because I wouldn't want to pay for it, and because I have enough faith in myself to be able to manage the trickier bits of Postgres.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by ashtonkem on Tuesday May 05, 2020 @12:43AM (#23076585)

To be fair, I have no idea how hard it was to manage Oracle vs. how much my DBA just liked to gripe. But I largely agree with you, except I would lean towards a managed service because I’m no DBA.

[ Parent | on HN ]