PostgreSQL 17 Released: JSON_TABLE and a Leaner Vacuum

What happened

PostgreSQL 17 was released on September 26, 2024, according to the PostgreSQL Global Development Group's official announcement. The release combined system-wide performance gains with developer-facing SQL/JSON additions and improvements to logical replication.

A leaner vacuum and faster I/O

PostgreSQL's vacuum process, essential for healthy operation, gained a new internal memory structure that consumes up to 20 times less memory, improving vacuum speed and freeing shared resources for the workload. The release also continued to improve the I/O layer: high-concurrency workloads may see up to 2x better write throughput thanks to write-ahead log improvements, and a new streaming I/O interface speeds up sequential scans and ANALYZE.

JSON_TABLE and SQL/JSON

PostgreSQL, which was the first relational database to add JSON support back in 2012, extended its SQL/JSON implementation. Version 17 added JSON_TABLE, which converts JSON data into a standard PostgreSQL table, along with SQL/JSON constructors and query functions such as JSON_EXISTS, JSON_QUERY and JSON_VALUE, and more jsonpath expressions. The MERGE command also gained a RETURNING clause and the ability to update views.

Logical replication for upgrades and HA

A notable operational improvement is that, starting with upgrades from PostgreSQL 17, users no longer have to drop logical replication slots during a major version upgrade, simplifying the process. The release added failover control for logical replication to make it more resilient in high-availability setups, and introduced the pg_createsubscriber tool to convert a physical replica into a logical one.

Why it mattered

PostgreSQL 17 delivered meaningful efficiency gains, especially the dramatically lower vacuum memory footprint, alongside standards-based JSON tooling that many developers had been waiting for. The logical-replication changes reduced friction around one of the hardest operational tasks, major-version upgrades, reinforcing PostgreSQL's position as a dependable open-source database.

Related on Skillo

See also: PostgreSQL 16 and its performance improvements.

Sources

• PostgreSQL 17 Released! (official announcement)

Published date reflects the original event date (2024-09-26). This article is original Skillo editorial written from the sources above; facts were verified in September 2026.