Postgres 14 released!

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

Overview

EDB Postgres offers an integrated, open-source-based SQL relational database solution built for your enterprise-scale data needs. A rich set of extended capabilities support cost-effective, resilient production and non-production environments. Organizations can come to IBM to license, implement and get support for EDB Postgres and enjoy the tested and certified PostgreSQL for high availability, disaster recovery, and monitoring.

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.

Explore IBM data ecosystems

SingleStore DB with IBM

SingleStore DB is a modern SQL database for data-intensive workloads. With near ubiquitous connectivity driving high-velocity, high-volume data workloads.

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.

Use cases

Migrate more apps from Oracle

conveyor belts in a factory

Migrate more apps from Oracle

Advanced queuing supports a range of application migrations from Oracle to EDB, including applications used for financial transactions, user profile data and system of record information.

Manage larger data sets

Sky view of a ship being loaded with containers

Manage larger data sets

Robust partitioning capabilities — including fast pruning for more data types and prepared statements — better enable EDB Postgres Advanced Server 9.6 to support clients with larger data sets.

Build better configurations

Several people doing sky diving

Build better configurations

Build more robust and flexible configurations using clustering, scale out and integration features. Use synchronous apply confirmation to build truly read scalable clusters.

Resources

IBM® Data Management 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.

EDB and IBM announce multiyear partnership

Learn about how IBM clients can take advantage of EDB Postgres.

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.