Postgres Plus Advanced Server®

Optimize your database mix with open source


  • Open source is proven to cut IT costs
  • Linux was first
  • Then came KVM and JBoss in the middle
  • Now it's time for your database
  • SCROLL down for more details. ▼


Bulking up open source with enterprise muscle


  • All the features of open source PostgreSQL, plus...
  • Advanced performance and security
  • Sophisticated developer and DBA tools
  • Database compatibility for Oracle®
  • SCROLL down for more details. ▼


Version 9.3 breaks through the partitioning performance barrier


  • Thousands of partitions now possible for a single table
  • More than 400 times faster INSERTs than v9.2 and PostgreSQL v9.3
  • More than 75 times the SELECT performance
  • Simple declarative partitioning syntax
  • SCROLL down for more details. ▼
The dirty little secret Oracle® does not want you to know


  • You don't need Oracle for most of your applications
  • Open source-based Postgres Plus is mission critical ready
  • You can save up to 90% using Postgres Plus, CAPEX FREE!
  • You did it for your OS, now it's time to do it with your database
  • SCROLL down for more details. ▼

Postgres Plus Advanced Server®

Advance Server Tab

Every data center has a sweet spot for Postgres Plus Advanced Server®.

Organizations of all sizes and types are cutting database costs wherever possible by deploying a capable low cost alternative to costly proprietary databases. This strategy reduces lock-in to a single vendor and gives IT managers more leverage when negotiating for lower costs. Controlling costs with expensive proprietary vendors has been proven with Linux for operating systems, Xen and KVM for virtualization and JBoss and Apache for middleware and is now being applied to databases. Compare costs with our online TCO calculator. 

NoSQL for the Enterprise

Advanced Server’s powerful combination of unstructured and relational database technologies in a single enterprise database management system provides the freedom, flexibility and performance of handling unstructured and semi-structured data while preserving its long-term viability as enterprise information.

The document and key-value store features in Advanced server provide the advantages of new NoSQL technologies plus the ability to integrate them into traditional corporate data infrastructures without data silos, operational complexity, loss of data integrity, and risk. Read more about NoSQL for the Enterprise.

Proven performance in enterprises and government.

A relentless focus on performance, security, and special tools over multiple releases continues to expand the range of solutions possible with Postgres Plus. Recent partitioning improvements, linear read performance scaling up to 64 cores, optimized locking techniques, and multiple performance boosting features handle the largest OLTP loads for many commercial, U.S. government, and non-profit organizations of all sizes and missions. View a cross section of our customers.  

Database compatibility creates a larger sweet spot for savings!

EDB's compatibility technology helps cap, reduce, or eliminate Oracle® fees using multiple strategies, while preserving your investment in Oracle volume licensing, infrastructure, skills and practices. For over 9 years, EnterpriseDB has built a solid practice around helping customers just like you save money for their applications built around PL/SQL, OCI, and Pro*C.

Oracle migration tools convert your schema and many applications run with few changes. Customer conversions of their easy to migrate applications take days or a few weeks. EDB services like the Oracle Migration Assessment quickly identify high-payback applications and the Migration Factory can take 100% of the burden off your staff and realize savings sooner. Re-training is minimal because of the Oracle-like tools provided by Postgres Plus Advanced Server, so you staff can continue leveraging their Oracle knowledge and skills against a low cost open source based alternative. Click the Database Compatibility tab above to read more.

A Garter Magic Quadrant Leader

In Gartner's 2014 Magic Quadrant for Operational Database Management Systems report, EnterpriseDB is recognized as a leader. Our recognition comes as Postgres gathers greater momentum with global brands embracing Postgres’ growing technical prowess. Postgres Plus Advanced Server enables enterprises to divert investment from the high license and maintenance fees paid to traditional databases, to more strategic IT objectives instead. Read Gartner's latest Magic Quadrant report. 

Use EnterpriseDB's best practices to optimize your database mix for cost savings.

There are many paths to finding and applying costs savings in your database portfolio including how you manage your existing volume license agreements. One method is moving existing and easy to migrate applications off their authorized volume licenses to Postgres Plus Advanced Server at a much lower cost. Then recycle the volume licenses to account for growth or hardware upgrades in your difficult to migrate or unqualified to migrate applications. A smart re-balancing of your database mix can result in you paying less in total fees with Postgres Plus Advanced Server than your current proprietary maintenance fees alone. Other strategies used by customers to deploy Postgres Plus Advanced Server include:

  • Building new OLTP and operational applications
  • Applying it to a class of applications based on specific criteria (SLAs, data size, concurrent users, etc.)
  • Addressing archival or read-only applications that don't justify expensive licenses
  • Building non-mission critical applications
  • Assigning it to particular business units or departments
  • Offloading reporting tasks from a master database as an inexpensive replication server

Read our white paper: Optimizing Open Source for Greater Database Savings and Control

We can help you create a path forward.

Our free Enterprise Enablement consultation will inventory your database portfolio and help you identify likely candidates for implementing Postgres Plus Advanced Server at a cost savings in the context of your business goals and current constraints. An inexpensive followup Migration Assessment service can then identify technical issues (if any) for each candidate application, map out a technical strategy for implementation, and estimate your costs savings allowing you to make informed decisions. Contact us for a consultation now.

Postgres Plus Advanced Server® has a proven track record supporting large transactional systems for thousands of users world-wide and around the clock. It is built upon and integrates every release of the world's most advanced open source database, PostgreSQL. EDB engineers then work continuously with our enterprise users to add features, tools and solutions like those described below to meet our customers demanding standards.

World Class Performance

Advanced Security

Database Compatibility

Enterprise Developer Features

Enterprise DBA Features

Tools for Scalability, HA, Performance, and more

Supported Platforms

A savings sweet spot in your Oracle® deployments.

If you can't replace Oracle, you can control costs.

Database compatibility explained…

We make managing change easy.

PostgreSQL vs Postgres Plus Advanced Server®

Feature Differences (Hold pointer over features for details)

Go to: Common Features 

Feature Differences PostgreSQL Postgres Plus
Advanced Server
General Differences

Note: All features marked: , are also compatible with Oracle®.

  Includes all PostgreSQL features and updates, plus additional:
    - Security features
    - Performance features
    - Developer features
    - DBA features
    - Compatibility with Oracle
    - Enterprise Tools
Enterprise Security Features
Row Level Security (VPD) ⊕   Yes
Enhanced Audit/Compliance   Yes
Server Procedural Language Protection (EDB*Wrap) ⊕   Yes
Enterprise Performance Features
Scalable Partitioning   Yes
Declarative Partitioning ⊕   Yes
Query Optimizer Hints ⊕   Yes
Infinite Cache   Yes
Enterprise Developer Features
Hierarchical Queries ⊕   Yes
19 pre-defined re-usable Function Packages Yes
Synonyms (public and private) ⊕   Yes
Extended Functions and Operators ⊕   Yes
Explicit Commit/Rollback in Stored Proc. ⊕   Yes
Bulk Collect and Binds ⊕   Yes
User defined object types ⊕   Yes
Nested Tables ⊕   Yes
User Defined Exceptions ⊕   Yes
User defined packages and functions ⊕   Yes
Associative Arrays ⊕   Yes
VARRAYs ⊕   Yes
edb_stmt_level_txn ⊕   Yes
EDB*Wrap ⊕   Yes
EDB*Plus ⊕   Yes
ECPGPlus   Yes
Enterprise DBA Features
Declarative Partitioning Syntax ⊕   Yes
EDB*Loader ⊕   Yes
SQL Session/System wait tuning diagnostics ⊕   Yes
Extended Catalog Views ⊕   Yes
DynaTune®   Yes
Database Compatibility for Oracle (also includes all features in table with the ⊕ symbol
PL/SQL Support in Stored Procedures and Triggers ⊕   Yes
PL/SQL Debugger ⊕   Yes
EDB*OCI ⊕   Yes
Enterprise Tools included in a subscription for: Standard Edition Enterprise Edition
EDB Backup and Recovery Tool Yes Yes
EDB Update Monitor Yes Yes
EDB Postgres Enterprise Manager Yes Yes
EDB SQL/Protect Yes Yes
EDB xDB Replication Server (single-master) Yes Yes
EDB Migration Toolkit ⊕ Yes Yes
EDB Failover Manager Extra Option Yes
EDB Replication Server (multi-master) Extra Option Yes


Common Features

Go to: Different Features

Common Features PostgreSQL Postgres Plus Advanced Server
Full ACID Compliance Yes Yes
Multi-Version Concurrency Control (MVCC) Yes Yes
Strong conformance to ANSI-SQL:2008 standard Yes Yes
ANSI Constraints Yes Yes
SQL USAGE privilege on types Yes Yes
Column Level Permissions Yes Yes
Per-Column Collations Yes Yes
Column Trigger Yes Yes
Primary/Foreign keys support Yes Yes
GIN & GiST Indexes Yes Yes
Function based Indexes Yes Yes
Composite Indexes Yes Yes
K-Nearest-Neighbor Indexes Yes Yes
Index-only Scans Yes Yes
Triggers and Stored Procedures Yes Yes
Views Yes Yes
View Security Barriers Yes Yes
Materialized Views (with concurrent refresh) Yes Yes
Unlogged Tables Yes Yes
SQL/MED Support Yes Yes
Library interface support for libpq, JDBC, ODBC, .NET, Python, C/C++, Perl, Ruby PHP and more. Yes Yes
Full Text Search, XML, JSON, JSONB support, HStore Key-Values support Yes Yes
Range Data Types Yes Yes
Writeable Common Table Expressions Yes Yes
Window Functions Yes Yes
Rules Engine Yes Yes
In-place version upgrades Yes Yes
Streaming Replication & Hot Standby Yes Yes
Logical Decoding Yes Yes
Online Backup and Point In Time Recovery Yes Yes
Online Index Reorganization Yes Yes
Hot restart with pg_prewarm Yes Yes
PostGIS spatial extensions support Yes Yes
Partitioning of Table and Indexes Yes Yes
Authentication support for LDAP, SSL, RADIUS, PAM, Kerberos, GSSAPI, SSPI, Trust, Password, Ident. Yes Yes


Function Package Descriptions for Postgres Plus Advanced Server

Return to Feature Differences - Packages

Package Name Package Description
DBMS_ALERT Allows asynchronous notification of database events via an Alert. Using this package and triggers, an application can notify itself whenever values of interest in the database are changed.
DBMS_CRYPTO Provides functions to encrypt and decrypt stored data.
DBMS_JOB Has been replaced by DBMS_SCHEDULER but included for compatibility with older Oracle applications.
DBMS_LOB Allows access to and manipulation of Large OBject values.
DBMS_LOCK Provides an interface to Lock Management services.
DBMS_OUTPUT Allows the sending of messages from stored procedures, packages, and triggers for application or debugging use.
DBMS_PIPE Functions that allow two or more sessions in the same database instance to communicate with one another.
DBMS_PROFILER Provides functions to profile SQL workloads and identify performance bottlenecks.
DBMS_SCHEDULER A job scheduler for creating and executing unattended repetitive tasks inside the database.
DBMS_SQL Permits the use of dynamic SQL in procedures to allow applications to run SQL statements with unknown parameters (such as table name) until runtime.
DBMS_RANDOM Useful functions to generate random text, numeric and date values.
DBMS_RLS Implements row level security in the database blocking users from seeing each other's data in the same application.
DBMS_UTLTITY A collection of functions for getting information about various runtime operations and meta data from the database.
UTL_ENCODE Functions to perform Base64 encoding and decoding of data intended for transport between hosts.
UTL_FILE Allows database procedures to read and write operating system text files in an I/O stream fashion.
UTL_HTTP Provides the ability to make HTTP calls to access information on the internet.
UTL_MAIL Provides functions to create,manage, and send email from the database including attachments, CC, and BCC.
UTL_SMTP Provides functions for sending mail via SMTP according to the RFC821 specification.
UTL_URL Provides functions for escaping and un-escaping URL strings.


Customer Success Stories

Sony Online Entertainment Replaces Oracle with EnterpriseDB
Massively Multiplayer Online Gaming Sony Online Entertainment LLC (SOE) is a recognized worldwide...
coresystems delivers mobile solutions for ERP and CRM using EnterpriseDB Postgres Plus in the Cloud
coresystems ag is the world leader in standardized additional solutions for SAP and Microsoft ERP...

Video: Postgres Plus Advanced Server

Watch this short video to learn how Postgres Plus Advanced Server enhances PostgreSQL with enterprise-class security, performance, manageability, and database compatibility.


The news is out!

EnterpriseDB is positioned in the Leaders Quadrant: Gartner Magic Quadrant for Operational Database Management Systems, 2014

Read the Magic Quadrant report...

How to Buy


Postgres Plus Advanced Server is in included with the purchase of an Enterprise Edition subscription. Please Contact Us to have an EDB representative process your order.

Contact Us to Purchase

Upcoming Events

PGCon 2015

2015-06-16 (All day) - 2015-06-19 (All day) Ottawa, Canada

Gartner Enterprise Information & Master Data Management Summit

2015-04-01 (All day) - 2015-04-02 (All day) Las Vegas, Nevada

PGConf NYC 2015

2015-03-25 (All day) - 2015-03-27 (All day) New York, NY

Gartner Enterprise Information & Master Data Management Summit UK

2015-03-11 (All day) - 2015-03-12 (All day) London, UK