Difference between PostgreSQL and Postgres Plus Advanced Server
Recently, I took up a opportunity to start working with the not-so-mainstream databases like PostgreSQL and Redis. It’s a really big challenge for me as I have worked with Oracle database for more than 4 years now. I started to research more on PostgreSQL and found a HUGE bunch of information. While I start to pickup on PostgreSQL, I hope to document the knowledge here.
What is PostgreSQL?
PostgreSQL is an open source relation database management system (RDBMS) that is supported on majority of the operating systems, including Unix, Linux and Windows. It is extremely mature, having more than 15 years of active development and a proven architecture which is quite similar to Oracle database.
Taken from PostgreSQL website
An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data. Some general PostgreSQL limits are included in the table below.
What is Postgres Plus Advance Server?
Postgres Plus Advance Server is a distribution of PostgreSQL maintained and supported by EnterpriseDB. It is usually used by companies who require maintenance support from a company.
Taken from Here.
EnterpriseDB adds additional functionality and capabilities in the following areas:
1. Database Feature Compatibility for Oracle
2. Performance Features
3. Productivity Tools – Postgres Enterprise Manager, xDB Replication Server and the Migration Toolkit
4. Indemnification (Read: SUPPORT)
Postgres Plus Advanced Server contains all the features and functionality of PostgreSQL and adds additional performance features, security, and database feature compatibility for Oracle. The performance features include: a SQL Profiler, Index Advisor, Query Hints, Infinite Cache, DynaTune, a Hi-speed bulk loader, Bulk Collect/Fetch/Binding, and Multi-threaded Replication. Security is improved with the addition of server side code obfuscation, fine grained audit logging and SQL injection attack prevention. Finally, Advanced Server provides database compatibility that includes: PL/SQL support, a PL/SQL Debugger, Oracle SQL Extensions, OCI support, User Defined Objects, popular Function Packages, Dictionary Views, Database Links, EDB*Plus, EDB*Wrap, and SQL wait statistics.
In my opinion, customers who are migrating from Oracle to PostgreSQL would go for the latter option as it provides plenty of compatibility support for Oracle databases. However, it’s always good to sign up for support contract for the open source version with them. You never know when you need the extra help!