| Feature |
PostgreSQL |
Postgres Plus Standard Server |
Postgres Plus Advanced Server |
| Primary Differentiators(s) |
One-click Installer StackBuilder |
Adds: Enterprise modules
Installation Tuning StackBuilder Plus (see below) |
Adds: Oracle Compatibility,
Performance,
Scalability, & DBA
and Developer Tools
|
| Supported Platforms |
Linux x86/32 Linux x86/64 Windows® |
Linux x86/32 Linux x86/64 Windows
|
Linux x86/32 Linux x86/64 Windows Solaris® x86/64 Solaris SPARC® |
| Full ACID compliance |
 |
 |
 |
| Views |
 |
 |
 |
| User Defined Data Types |
 |
 |
 |
| ANSI Constraints |
 |
 |
 |
| Function based Indexes |
 |
 |
 |
| Partial Indexes |
 |
 |
 |
| Data and Index Partitioning |
 |
 |
 |
| Bitmap Indexes |
 |
 |
 |
| Primary and Foreign keys |
 |
 |
 |
| Column Level Permissions |
 |
 |
 |
| Rules Engine |
 |
 |
 |
| Inheritance |
 |
 |
 |
| Triggers & Stored Functions |
 |
 |
 |
| Windowing Functions |
 |
 |
 |
| Recursive Queries |
 |
 |
 |
| Nested Transactions |
 |
 |
 |
| Procedural Language support |
 |
 |
 |
| SQL/XML Support |
 |
 |
 |
| Multi-version Concurrency Control (MVCC) |
 |
 |
 |
| Full Text Search |
 |
 |
 |
| PostgreSQL Database Links |
 |
 |
 |
| Pluggable Authentication |
 |
 |
 |
| Heap-Only Tuples (HOT) |
 |
 |
 |
| GUI Administration Console (pgAdmin) |
 |
 |
 |
| Point-in-Time Recovery (PITR) |
 |
 |
 |
| Online Index Reorganization |
 |
 |
 |
| Online Backup |
 |
 |
 |
| Parallel Restore |
 |
 |
 |
| Interactive SQL Terminal |
 |
 |
 |
| Client Connectors |
libpq
ECPG
|
libpq
ECPG
pgJDBC
psqlODBC
Npgsql(.NET)
|
libpq
ECPG
pgJDBC
psqlODBC
Npgsql(.NET)
OCL(OCI)
|
| Authentication support |
Trust
Password
GSSAPI
SSPI
Kerberos
Ident
LDAP
SSL
PAM
|
Trust
Password
GSSAPI
SSPI
Kerberos
Ident
LDAP
SSL
PAM
|
Trust
Password
GSSAPI
SSPI
Kerberos
Ident
LDAP
SSL
PAM
|
| Distributed Memory Caching (pgmemcache) |
|
 |
 |
| Integrated Connection Pooling (pgBouncer) |
|
 |
 |
| Job Scheduler (pgAgent) |
|
 |
 |
| Postgres Replication (Slony) |
|
 |
 |
| GeoSpatial Support (PostGIS) |
|
 |
 |
| PL/pgSQL Debugger |
|
 |
 |
| Integrated Add-On Components |
|
 |
 |
| Installation Tuning |
|
 |
 |
| Automatic Update Notification |
|
 |
 |
| Open Source Database Migration |
|
 |
 |
| Standby Database for Disaster Recovery |
|
 |
 |
| Certified Binaries |
|
 |
 |
| DynaTune® |
|
|
 |
| SQL/Protect |
|
|
 |
| User Defined Object Types |
|
|
 |
| Oracle Dictionary Views |
|
|
49 |
| EDB*Loader |
|
|
 |
| Oracle SQL Extensions |
|
|
 |
| Object Types support |
|
|
 |
| Oracle Database Links |
|
|
 |
| Infinite Cache (includes DB-in-Cache) |
|
|
 |
| Asynchronous Pre-Fetch for RAID |
Bitmap Indices |
Bitmap Indices |
Bitmap Indices Regular Indices |
| GridSQL® with Parallel Query |
|
|
 |
| Bulk Collect / Bulk Bind |
|
|
 |
| Query Optimization Hints |
|
|
 |
| DRITA (Dynamic Runtime Instrumentation) |
|
|
 |
| EDB*Plus |
|
|
 |
| PL/SQL Support |
|
|
 |
| PL/SQL Debugger |
|
|
 |
| EDB*Wrap (source code protection) |
|
|
 |
| EDB*Package (built-in code packages) |
|
|
DBMS_ALERT
DBMS_JOB
DBMS_LOB
DBMS_OUTPUT
DMBS_PIPE
DBMS_SQL
DBMS_UTLTITY
UTL_FILE
UTL_MAIL
UTL_SMTP
|
| User Defined Packages |
|
|
 |
| Explicit Transaction Control |
|
|
 |
| EDB*OCI |
|
|
 |
| GridSQL Monitoring Console |
|
|
 |
| Multi-threaded Oracle Replication |
|
|
 |
| Oracle Replication Server |
|
|
 |
| Oracle Replication Console/CLI |
|
|
 |
| Migration Studio
|
|
|
MySQL
Oracle
SQL Server
Sybase
|
| DBA Management Server |
|
|
 |
| DBA Monitoring Console |
|
|
 |
| Indemnification and Warranties |
|
|
 |
| Audit Logging |
|
|
 |
| Programming Language Support |
PL/pgSQL PL/Java® PL/Ruby PL/Python
PL/PHP PL/Perl C/C++ PL/Tcl PL/Scheme
|
PL/pgSQL PL/Java® PL/Ruby PL/Python
PL/PHP PL/Perl C/C++ PL/Tcl PL/Scheme
|
PL/SQL PL/pgSQL PL/Java® PL/Ruby PL/Python
PL/PHP PL/Perl C/C++ PL/Tcl PL/Scheme
|
| Library Interface Support |
libpq JDBC ODBC .NET™ Perl Python
Ruby C/C++ PHP Lisp Scheme Qt
|
libpq JDBC ODBC .NET Perl Python
Ruby C/C++ PHP Lisp Scheme Qt
|
OCL(OCI) libpq JDBC ODBC .NET Perl Python
Ruby C/C++ PHP Lisp Scheme Qt
|
| StackBuilder (Plus) Modules |
MySQL Migration .NET Connector
pgJDBC Connector psqlODBC Conn.
Tuning Wizard Slony-I Replication
PostGIS GeoSpatial pgPhoneHome Drupal mediaWiki
phpBB phpWiki ApachePHP phpPgAdmin
|
Postgres Plus HQ
xDB Replica. Server
PL/Secure
Migration Toolkit pgAgent Jobs
PgBouncer
pgmemcache library
MySQL Migration .NET Connector
pgJDBC Connector psqlODBC Conn.
Tuning Wizard Slony-I Replication
PostGIS GeoSpatial pgPhoneHome Drupal mediaWiki
phpBB phpWiki ApachePHP phpPgAdmin
|
Postgres Plus HQ
xDB Replica. Server
(use EDB*Wrap)
Migration Toolkit pgAgent Jobs
PgBouncer
pgmemcache library
MySQL Migration .NET Connector
pgJDBC Connector psqlODBC Conn.
(use DynaTune) Slony-I Replication
PostGIS GeoSpatial pgPhoneHome Drupal mediaWiki
phpBB phpWiki ApachePHP phpPgAdmin
|