Postgres 17 New Features Every Developer Should Know

PostgreSQL 17 dropped in late 2024 and quietly improved nearly every operational pain point.

1. JSON_TABLE for SQL/JSON

Convert JSON straight into a relational result set:

SELECT t.* FROM
  orders,
  JSON_TABLE(items, '$[*]' COLUMNS (
    sku    text PATH '$.sku',
    qty    int  PATH '$.qty',
    price  numeric PATH '$.price'
  )) AS t;

No more jsonb_array_elements gymnastics for common cases.

2. Incremental backups

pg_basebackup --incremental=... ships a delta against the previous full backup. Combined with pg_combinebackup, point-in-time recovery is dramatically faster and cheaper.

3. Smarter vacuum

The new vacuum memory layout uses ~20× less RAM for indexes. Long-running vacuums on huge tables are finally feasible without out-of-memory tuning.

4. COPY ... FROM reports row counts

Much better progress observability for bulk loads.

5. Better logical replication

• Failover slots now survive promotion.
• Sequences replicate.
• DDL replication is opt-in for many statements.

6. SQL standard catch-up

MERGE gained RETURNING and WHEN NOT MATCHED BY SOURCE. Application upserts are now expressible without the classic CTE workarounds.

Upgrading

pg_upgrade --link --jobs=N is your friend. As always, run vacuum analyze immediately after.