What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts

Friends, the annual PostgreSQL major release is here. PostgreSQL 17 was officially announced on 2024‑09‑26.

Note: the "relational" qualifier has been dropped – it is now simply the world’s most advanced open‑source database.

System performance improvements

The new vacuum internal memory structure reduces memory consumption up to 20×, dramatically speeding up vacuum and freeing shared resources. Write throughput for high‑concurrency workloads can increase up to two‑fold thanks to WAL handling improvements. A new streaming I/O interface accelerates sequential scans and ANALYZE statistics collection.

Query execution also benefits: IN clause queries on B‑tree indexes are faster, BRIN indexes now support parallel build, and optimizations for NOT NULL constraints and WITH queries have been added. SIMD support has been expanded, including AVX‑512 for the bit_count function.

Enhanced developer experience

PostgreSQL 17 adds full support for the SQL/JSON JSON_TABLE command and implements the SQL/JSON constructor functions JSON, JSON_SCALAR, and JSON_SERIALIZE, as well as query functions JSON_EXISTS, JSON_QUERY, and JSON_VALUE. New jsonpath expressions allow conversion of JSON data to native PostgreSQL types.

The MERGE command now supports RETURNING and view updates. Bulk loading and export via COPY see up to 2× performance gains, and a new ON_ERROR option lets imports continue after row errors.

Logical replication and high‑availability enhancements

Logical replication slots no longer need to be dropped for major version upgrades, simplifying migration. Fail‑over control for logical replication has been added, and the new command‑line tool pg_createsubscriber converts physical replicas into logical ones.

Security and operational management options

A new TLS option sslnegotiation enables direct TLS handshakes using ALPN. The predefined role pg_maintain grants maintenance privileges. pg_basebackup now supports incremental backups, complemented by the pg_combinebackup utility for rebuilding full backups. pg_dump introduces a --filter option to select objects during dump generation. The EXPLAIN command now reports local I/O timing and includes SERIALIZE and MEMORY options for network transfer and memory usage insights. New system view pg_wait_events works with pg_stat_activity to reveal session wait reasons.

Other notable features

Block‑level incremental backup and recovery via pg_combinebackup.

Logical replication failover and switchover support.

Enhanced COPY error handling with skip‑error rows.

Improved JSON handling and expanded jsonpath capabilities.

Vacuum performance gains using the TidStore data structure.

Parallel BRIN index creation and incremental sorting for GiST/SP‑GiST indexes.

High‑concurrency lock contention optimizations through WAL lock improvements.

Various performance boosts for bulk import, MERGE append, group‑by, partition‑wise joins, and more.

New GUC parameters for finer database management control.

SQL syntax and function enhancements: partition split/merge, generated columns, exclude constraints, etc.

Management improvements: login event support, new maintenance role, read‑write split consistency functions, transaction timeout.

Extended statistics and system views: wait‑event view, enhanced checkpoint, parallel operation, range‑type, standby, and I/O statistics.

Table access method interface enhancements and early undo segment support.

Extended plugin hooks, custom wait events, DSM registration, and other extensibility improvements.

Wire protocol and libpq enhancements for better compatibility.

About PostgreSQL

PostgreSQL is a globally developed open‑source database with over 35 years of engineering history, originating from UC Berkeley. It offers advanced features, scalability, security, and stability that rival or exceed top commercial databases.

Community commentary

One commentator notes that PostgreSQL’s write throughput can double, highlighting the “plain‑vanilla strength” of the release. They also emphasize the community’s mindset shift: dropping “relational” from its slogan and positioning PostgreSQL as the world’s most advanced open‑source database.

Further reading

For a detailed feature list, see the blog post “PostgreSQL 17 正式发布, 要不要升?” and the accompanying summary of 17’s new capabilities.