PostgreSQL 
Porównanie wersji
Porównanie wersji
Porównanie wersji
19 September 2010
Maksymalne wielkości elementów bazy danych Postgres Plus
| Maximum Database Size | Unlimited |
| Maximum Table Size | 32 TeraBytes (TB) |
| Maximum Row Size | 1.6 TB |
| Maximum Field Size | 1 GB |
| Maximum Rows per Table | Unlimited |
| Maximum Columns per Table | 250 - 1600 depending on column types |
| Maximum Indexes per Table | Unlimited |
Porównanie wersji
| 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 | |
|
|
| Functional Indexes | |
|
|
| Partial Indexes | |
|
|
| Data and Index Partitioning | |
|
|
| Bitmap Indexes | |
|
|
| Primary and Foreign keys | |
|
|
| Rules Engine | |
|
|
| Inheritance | |
|
|
| Triggers & Stored Functions | |
|
|
| 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 | |
|
|
| 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® | |
||
| 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 |
Not yet available. |
- RH423 Warszawa
May 21, 2012(09:00) - May 24, 2012 (10:00) - RHS333
May 21, 2012(09:00) - May 24, 2012 (09:00) - JB336 Warszawa/Kraków
May 21, 2012(10:00) - May 24, 2012 (10:00) - RH255 Warszawa
May 21, 2012(10:00) - May 25, 2012 (10:00) - EX300 Warszawa/Kraków
May 25, 2012 (10:00 - 11:00)
