Postgres Plus® Advanced Server

The only RDBMS challenger to Oracle®, IBM®, Microsoft® and SAP®

 

  • EnterpriseDB enters the Gartner Magic Quadrant for Operational Database Management Systems (*)
  • This Magic Quadrant deals with the key capabilities of information management for transaction processing
  • EDB recognized for database compatibility and ability to support mission critical applications
  • SCROLL down for more details. ▼

(*) Read the Gartner Magic Quadrant for Operational Database Management Systems

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. ▼

(*) See the Garter Magic Quadrant for Operational Database Management Systems

 
 

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 Challenger

In Gartner's 2013 Magic Quadrant for Operational Database Management Systems, EnterpriseDB stands alone as the only RDBMS deemed a Challenger to the big 4 proprietary databases from IBM, Oracle, Microsoft and SAP. Gartner summarized the enterprise readiness of Postgres Plus Advanced Server this way: "The functionality of EnterpriseDB's Postgres Plus has increased greatly, and with the Oracle Compatibility Feature is now more than sufficient to run both mission-critical and non-mission-critical applications." 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:

  • use it for building new OLTP and operational applications,
  • apply it to a class of applications based on specific criteria (SLAs, data size, concurrent users, etc.)
  • address archival or read-only applications that don't justify expensive licenses,
  • build non-mission critical applications,
  • assign it to particular business units or departments,
  • use it to offload 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
    - Database Compatibility
    - 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)
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 Update Monitor Yes Yes
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
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 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 and JSON 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
Online Backup and Point In Time Recovery Yes Yes
Online Index Reorganization 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...

How to Buy

img

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

PostgreSQL Conference Europe 2014

2014-10-21 (All day) - 2014-10-24 (All day) Madrid, Spain

Postgres Open

2014-09-17 (All day) - 2014-09-19 (All day) Chicago, IL

Inforum 2014

2014-09-15 (All day) - 2014-09-18 (All day) New Orleans, LA

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.