10 weaknesses of PostgreSQL compared to Oracle Database and YugabyteDB
PostgreSQL is the most relevant open-source database when wanting to replace the Oracle Database with a non-proprietary solution. The main reasons for this popularity are the set of functionalities, SQL and PLSQL similarities, and migration tools available. But there are also some known weaknesses when used at enterprise level, like vacuum, transaction wraparound, lack of online upgrade and scale-out solutions. Those are acceptable for small databases, but cannot compete with Oracle Enterprise features, and RAC or Data Guard. There are multiple open-source projects that keep the PostgreSQL features, and leverage the postgres extensibility to plug it on a modernized storage engine. YugabyteDB is one of them, bringing the scalability and resilience of a cloud-native architecture.
In this presentation, we will take the 10 points from Rick Branson's "10 Things I Hate About PostgreSQL" and see how they map to Oracle and YugabyteDB. The goal is to help identify which workload can run on PostgreSQL, should stay on Oracle, or can scale on YugabyteDB. Do not expect a battle but a fair analysis on the current state of enterprise databases and available postgres-compatible alternatives.
Die Präsentation findet am Mittwoch, den 21. September 2022 um 13:00 Uhr (CEST) im Raum Shanghai statt.
Der Referent ist Franck Pachot, YugaByte, ORACLE ACE Director