BACKGROUND IMAGE: iSTOCK/GETTY IMAGES
PostgreSQL is an open source relational database management system. Its development is managed by the PostgreSQL Global Development Group and it's made available under the terms of the PostgreSQL License. PostgreSQL, which evolved from the Ingres project at the University of California, Berkeley led by Michael Stonebraker, was one of the first relational database systems created.
PostgreSQL serves as the foundation for the EDB Postgres platform from EnterpriseDB. This open source-based operational data management platform brings together multiple components for managing structured and unstructured data in a federated model. The platform makes integration across different databases (supporting relational, document and key-value databases) possible, enabling users to combine unstructured data with structured, transactional data.
The EnterpriseDB Postgres platform includes a database management system (DBMS), three fully integrated tool suites, a range of deployment options, and support and services. The platform offers the following:
- A choice between PostgreSQL 9.5 or EDB Postgres Advanced Server 9.5, a version of PostgreSQL 9.5 enhanced with enterprise-class performance, scalability, and security features and capabilities.
- The Management Suite, which consists of a family of tools that provide disaster recovery, high availability, monitoring, management and tuning capabilities.
- The Migration Suite, which enables organizations to migrate workloads from other products, including Oracle products, using the database compatibility for Oracle that EDB developed.
- The Integration Suite, which features a collection of tools that support the replication of data, such as the EDB Postgres Replication Server for single and multimaster replication, and the integration of EDB Postgres with other databases, such as MongoDB and Hadoop.
EDB Postgres software can be deployed on bare metal or virtually, including in container environments or in public, private and/or hybrid cloud environments. The private cloud is based on OpenStack and the public cloud includes Amazon Web Services and the Google Cloud Platform. Hybrid configurations are also supported.
Current version highlights
PostgreSQL 9.5 introduced the following key features:
- UPSERT operations, with new syntax to help resolve conflicts.
- Block range indexes to speed up queries on large tables by indexing ranges of values for searches.
- New operators and functions to modify JSONB data directly in tables.
- Grouping sets to enable database administrators to run multiple GROUP BYs in a single query.
- CUBE and rollups for analytics.
PostgreSQL 9.5 can support greater data volumes, thereby increasing performance as a result of the higher optimization of the locking regime in shared buffers. It can also support more concurrent users in high-transactional systems. Performance is increased as a result of expanded, concurrent locking through a reduced number of page locks and pins holding indexes during scans. PostgreSQL 9.5 supports a greater number of shared buffer partitions through enhanced shared buffer management and mapping. Using an abbreviated sorting optimization, PostgreSQL 9.5 can sort large text and numeric fields 20% to 30% faster than PostgreSQL 9.4.
EDB Postgres Advanced Server 9.5 offers additional enhancements, such as improved security with expanded password profiles, vertical scaling optimization, new package support for UTL_RAW and DBMS_SESSION, expanded support for UTL_HTTP, expanded auditability with audit log tagging, and expanded scalability improvements for locking subsystems.
The EDB Postgres platform's compatibility with Oracle makes it easier to migrate from Oracle to EDB, in addition to enabling developers to use Oracle skills in new Postgres Advanced Server applications.
The EnterpriseDB Postgres platform can run on the following operating systems:
- Linux x86-64: Ret Hat Enterprise Linux (RHEL)/CentOS/Oracle Enterprise Linux 7.x and 6.x, SUSE Linux Enterprise Server 12.x and 11.x, Ubuntu 14.04 Long-Term Support, Debian 7.x.
- Windows x86-64: Windows 2012 R2, Windows 2008 R2.
- Linux on IBM POWER8 Little Endian: RHEL 7.
Licensing, pricing and performance
The EDB Postgres platform is sold as a comprehensive subscription that includes all of the software, support, maintenance and upgrades. There are three different subscriptions available. EDB Postgres Enterprise Edition is for customers that choose EDB Postgres Advanced Server as their DBMS. The EDB Postgres Standard Edition is for customers that choose PostgreSQL as their DBMS. EDB Postgres Developer Edition is for customers in the development stage only, and it can be applied to either DBMS.
Support and services complement the Postgres ecosystem provided to EDB customers, as 24/7 global support and upgrades are included with EDB Postgres platform subscriptions and professional services and training.
PostgreSQL can be downloaded as open source software free of charge. EnterpriseDB sells directly and through a global network of partners worldwide, including Dell EMC and Hewlett Packard Enterprise. Pricing is based on the processor core for developer and production deployment. EDB also offers hourly pricing for public clouds such as Google and Amazon Web Services.
Customers can try a 60-day trial of the EnterpriseDB Postgres Advanced Server database and tool suites.
The relational database remains the technology of choice
Relational vs. NoSQL DBMS security features: What's the difference?
Identifying database performance issues