| Feature |
PostgreSQL |
Postgres Plus Advanced Server |
| Primary Differentiators(s) |
|
Adds:
- Performance
- Security Features
- Oracle Compatibility |
| Supported Platforms |
Linux x86/32
Linux x86/64
Windows®
|
Linux x86/32
Linux x86/64
Windows
HP-UX Itanium
Solaris® x86/64
Solaris SPARC® |
| Client Connectors |
libpq
ECPG
|
libpq
ECPG
pgJDBC
psqlODBC
Npgsql(.NET)
OCL(OCI) |
| Distributed Memory Caching (pgmemcache) |
|
 |
| Integrated Connection Pooling (pgBouncer) |
|
|
| Job Scheduler (pgAgent) |
|
|
| PL/pgSQL Debugger |
|
|
| SQL Code Profiler |
|
|
| Integrated Add-On Components |
|
|
| Installation Tuning |
|
|
| Automatic Update Notification |
|
|
| Open Source Database Migration |
|
|
| Certified Binaries |
|
|
| DynaTune® |
|
|
| Index Advisor |
|
|
| SQL/Protect |
|
|
| User Defined Object Types |
|
|
| Oracle Dictionary Views |
|
57 |
| Parallel Bulk Loader (EDB*Loader) |
|
|
| Oracle SQL Extensions |
|
|
| Oracle Database Links |
|
|
| Virtual Private Database |
|
|
| Asynchronous Pre-Fetch for RAID |
Bitmap Indices
|
Bitmap Indices
Regular Indices |
| Infinite Cache |
|
|
| Bulk Collect/Fetch/Bind |
|
|
| Query Optimization Hints |
|
|
| DRITA (SQL wait state finder) |
|
|
| EDB*Plus |
|
|
| PL/SQL Support |
|
|
| PL/SQL Debugger |
|
|
| EDB*Wrap (server side source code protection) |
|
|
| EDB*Package (built-in function packages) |
|
DBMS_PROFILER
DBMS_ALERT
DBMS_JOB
DBMS_LOB
DBMS_OUTPUT
DBMS_PIPE
DBMS_SQL
DBMS_UTLTITY
UTL_FILE
UTL_MAIL
UTL_SMTP |
| User Defined Packages |
|
|
| Explicit Transaction Control |
|
|
| EDB*OCI |
|
|
| xDB Replication Server |
|
Oracle
SQL Server
PostgreSQL |
| xDB Replication Server GUI/CLI |
|
|
| Multi-threaded Oracle Replication |
|
via xDB Replication Server
|
| Migration Toolkit |
|
MySQL
Oracle
SQL Server
Sybase |
| Partitioning commands |
|
|
| Audit Logging |
|
|
| Programming Language Support |
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 |
OCL(OCI)
libpq
JDBC
ODBC
.NET
Perl
Python
Ruby
C/C++
PHP
Lisp
Scheme
Qt |
