3 ms·
Technically. In two different jobs now I've seen a small army of consultants unable to keep an Oracle cluster running as reliably as a single Postgres instance,
by cageface 16y ago
Technically. In two different jobs now I've seen a small army of consultants unable to keep an Oracle cluster running as reliably as a single Postgres instance, despite jaw-dropping license fees. It's also pretty painful to use, from simple command-line interactions to dumping & restoring data to interfacing with any code that isn't "enterprise". Blob performance was also astonishingly bad.
I guess you're stuck with it if you need to run Oracle financials or Peoplesoft or something like that but one of my professional goals is to never work for another company big or dumb enough to use either.
- gaius 16y agoThat says more about consultants than it does about Oracle ;-) Oracle (the database) in the hands of anyone basically competent is easily capable of 5-9s reliability. Not that I'm saying Postgres isn't mind. I'm just saying, use the right tool for the job (and hire the right people). I find DataPump very easy to use, and very fast, it's I/O bound even on serious storage arrays. YMMV. SQL*Plus is definitely showing its age I agree.
- CrLf 16y agoIt would be surprising if consultants could keep anything running reliably. In my experience, they provide nothing but chaos and half-baked solutions.