Postgres 14 released!

A variety of new features that help developers and administrators deploy their data-backed applications.

Overview

EDB, with IBM, offers a single source for purchase, deployment and support of EDB Postgres Enterprise and Standard editions based on PostgreSQL. Develop and run applications on a security-rich, enterprise-class database based on open source PostgreSQL.

EDB Postgres is available on IBM Cloud Pak® for Data so you can provide quality data to deliver accurate, automated insights and decisions. The solution is cloud-native by design and built on Red Hat® OpenShift®.

Benefits

Feature spotlight

Enterprise security

Icon showing incomplete concentric circles

Enterprise security

EDB delivers security through ANSI SQL GRANT and REVOKE. It offers external authentication support for LDAP, PAM and Kerberos. It also offers granular object permissions, operational auditing, a virtual private database, and protection against SQL injection attacks.

Advanced performance

Icon of abstract bar graph

Advanced performance for critical workloads

Advanced partitioning enable smarter, faster partition pruning. Ensure critical transactions have resource priority over other workloads. Dynamic Runtime Instrumentation Tools Architecture (DRITA) analyzes system and session wait events to identify bottlenecks.

Database compatibility

Icon of abstract dots connected to each other in a random pattern

Database compatibility to minimize migration efforts

EDB natively processes existing PL/SQL programs and data without translation layers and without costly consulting engagements. EDB compatibility means your performance expectations are preserved, intellectual capital is protected and staff can focus on important tasks.

DBA and developer features

Icon depicting person looking at computer screen

DBA and developer features

EDB provides tools and functionality such as EDB*Loader and extended catalog views. Twenty-one packages with more than 250 functions, bulk collect and bind, user-defined object types, and more reduce programming effort and provide faster processing.

Featured product

What’s new in Postgres 14

Scalability and performance

Scalability and performance

PostgreSQL 14 delivers huge gains in the performance of updates and deletes on tables that have a large number of partitions. Most importantly, we now scale to even more partitions than before, allowing PostgreSQL to cope with much larger databases than was previously possible. Applications with larger JSON and XML documents will be enhanced by a new compression option for TOASTed data, LZ4. The new method uses the latest compression technology to greatly improve the speed of compression and decompression of document data.

Enhanced security

Enhanced security

The default authentication for PostgreSQL going forward has now changed to SCRAM-SHA-256 to ensure that new users take full advantage of this important security feature, deprecating MD5 for new users.

Standardization

Standardization

Server-side functions and procedures that use LANGUAGE SQL can now use SQL-standard compliant function bodies. Graph-query support is enhanced by SEARCH and CYCLE clauses, which improve the ease of writing complex graph queries in PostgreSQL.

Developer friendly

Developer friendly

Stored procedures give transactional control within the code base. PostgreSQL 14 implements the OUT parameter, allowing developers to return data using multiple parameters in their stored procedures. A common feature within Oracle, this functionality is a welcome addition for developers trying to migrate from Oracle to PostgreSQL.

Related products

IBM Cloud Pak for Data

Built on Red Hat® OpenShift®, IBM Cloud Pak for Data modernizes how you collect, organize and analyze data and infuse AI in your organization.

MongoDB Enterprise Advanced with IBM

A robust, scalable, highly available document database solution that enables developers to build apps faster and better distribute data.

Open source databases

IBM open source database solutions help implement a hybrid data environment that includes both relational and non-relational components.

Resources

IBM® Data Management Platform for EDB Postgres Enterprise

Learn how to integrate open source databases into your existing data management solution.

Deploying Postgres databases in containers

Read up on the advantages of containerized databases and how EDB accelerates that process.

EnterpriseDB and IBM announce multiyear partnership

Read about the IBM-EnterpriseDB partnership from EDB’s President and CEO, Ed Boyajian.

IBM and EDB enhance Postgres solution

Learn about using open source databases and the benefits of the Enterprise and Standard editions.

Code pattern for helpdesk service ticket app

Create a web application that tracks support tickets using EDB and Vue.js.

Talk to an IBM expert to help you build a modernized, enterprise-ready data architecture with PostgreSQL.