3 ms·
It's true. Now, completely without benchmarks, I can tell you that my workplace has migrated from Oracle to Postgresql and performance is essentially the same:
by dsr_ 4y ago
It's true.
Now, completely without benchmarks, I can tell you that my workplace has migrated from Oracle to Postgresql and performance is essentially the same: a few things were a little faster on Oracle, a few a little faster on PG. All revenue is directly or indirectly dependent on the database systems, which have been continuous for 20+ years: this is not a side-project.
PG administration is much, much faster. Starting an Oracle database always involves a wait similar to booting an elderly operating system. Starting a PG database is fast. Things that Oracle will want to up-charge you to an Enterprise Edition license for, PG has for free. Want to spin up a new machine? No need to negotiate a new license with PG. The cost of the Oracle license would routinely be so large that you need to buy awesome hardware to justify it. You can install PG on anything, and justify it.
- tiffanyh 4y agoDoes your database run on NVMe storage? I ask because NVMe has neutralized a ton of performance differences across data related products.
- dsr_ 4y agoIt did in the last generation of Oracle and this generation of PG.
- thr717272 4y agoNot only that but Postgres doesn't take two days to install properly. (Admittedly I'm talking a full from scratch Red Hat server with Oracle DB, Oracle managed data disks and Apex, bit still.)