What’s New in PostgreSQL 16? Key Features That Boost Security, Replication, and Performance

PostgreSQL 16 introduces major updates in permission management, logical replication, performance, and monitoring.

On September 14, 2023, the PostgreSQL global development group released PostgreSQL 16, setting new standards for database management, data replication, system monitoring, and performance optimization.

Permission Management

PostgreSQL 16 overhauls permission management, allowing administrators to grant ADMIN OPTION roles only to users who already possess the necessary privileges, reducing reliance on superuser accounts and enabling finer‑grained role definitions.

Logical Replication Enhancements

Since its introduction in PostgreSQL 10, logical replication has been enhanced in each release. PostgreSQL 16 adds support for logical replication from a physical standby, enabling simpler geographic distribution and reducing primary node load. The new pg_log_standby_snapshot() function facilitates this.

Additional improvements include binary‑format initial table sync, replication of tables without primary keys, and increased security by requiring subscription owners to have SET ROLE privileges or be superusers.

Performance Improvements

Query execution now supports parallel execution of FULL and RIGHT JOINs and aggregation functions string_agg and array_agg. SELECT DISTINCT benefits from incremental sorting. Concurrent batch loading with COPY sees performance gains up to 300%.

New caching for RANGE and LIST partition lookups, as well as better control of shared buffers during VACUUM and ANALYZE, further boost efficiency.

Comprehensive Monitoring Features

PostgreSQL 16 adds the pg_stat_io view for detailed I/O activity insight, providing system‑wide statistics on reads, writes, and extensions per backend type.

It also records the last sequential and index scans per table, adds lock speculation information via pg_locks, and improves wait event reporting, delivering more thorough monitoring.

Enterprise and Cloud Availability

PostgreSQL 16 will debut on EDB BigAnimal next month, a cloud‑ready DBaaS platform that lets organizations run the full feature set in their preferred public cloud environments.