What’s New in PostgreSQL 17? Performance Boosts, JSON/SQL Enhancements, and More

PostgreSQL 17 was released on 26 September 2024. It adds a broad set of performance, scalability, and developer‑experience improvements while maintaining full compatibility with the PostgreSQL ecosystem.

System‑wide performance improvements

Vacuum memory redesign : a new internal memory structure reduces vacuum’s RAM consumption by up to 20 ×, which shortens vacuum duration and lowers pressure on shared buffers.

Write‑ahead log (WAL) enhancements : the WAL processing pipeline has been re‑engineered, delivering up to a 2× increase in write throughput for high‑concurrency workloads.

Streaming I/O interface : a new sequential‑scan I/O path speeds up full‑table scans and the statistics‑gathering phase of ANALYZE.

Query execution :

IN‑clause predicates that use B‑tree indexes are executed faster.

BRIN indexes can now be built in parallel, reducing index‑creation time on large tables.

Planner optimizations improve handling of NOT NULL constraints and common‑table‑expression (CTE) queries.

Additional SIMD instructions are used for arithmetic and hash‑based operations, further accelerating calculations.

Enhanced developer experience

SQL/JSON support : PostgreSQL 17 implements the SQL/JSON standard, introducing the JSON_TABLE construct that maps JSON documents to relational rows, plus JSON constructors and query functions for richer JSON manipulation.

MERGE command extensions : the MERGE statement now supports conditional updates, a RETURNING clause, and the ability to update materialized or regular views.

Bulk data handling : the COPY command has been tuned to deliver higher throughput when exporting or importing very wide rows.

Logical replication enhancements

Upgrading a cluster that uses logical replication no longer requires dropping replication slots; the slots are preserved automatically.

New fail‑over controls make logical replication more resilient in high‑availability deployments, allowing smoother switchover and fail‑over procedures.

Security and operational options

New TLS configuration parameter sslnegotiation gives administrators finer control over TLS handshake behavior.

Predefined role pg_maintain is introduced to delegate maintenance‑related privileges without granting full superuser rights.

Additional notes

For a complete list of changes, see the official release notes at https://www.postgresql.org/docs/17/release-17.html.