Devii · Data & analytics · 2026-03-29 · 8 min read
PostgreSQL 18 (2025–2026): AIO, Protocol 3.2, And Upgrade-Friendlier Majors
What matters for teams in 2026: PostgreSQL 18 as the current major, async I/O, wire-protocol updates, and routine minors (e.g. 18.3) in active support.
The PostgreSQL Global Development Group shipped **PostgreSQL 18** in **September 2025** (see postgresql.org release notes and press kit). Headline themes include an **asynchronous I/O (AIO)** subsystem aimed at faster sequential scans, bitmap heap scans, and vacuum on supported configurations, plus broader use of multicolumn B-tree indexes via **skip scan**-style plans.
Developers get practical tools such as **`uuidv7()`** for time-ordered UUIDs, virtual **generated columns**, and **`OLD` / `NEW` in `RETURNING`** for `INSERT`/`UPDATE`/`DELETE`-check the 18.x docs for exact syntax and limitations. PostgreSQL **18** also introduces **wire protocol 3.2**; clients and poolers adopt it gradually while **libpq** remains on 3.0 by default.
Through **2026**, follow **18.x minors** (bug and security fixes) on the same cadence you already use for 17.x. Major upgrades still require `pg_upgrade`, logical replication, or dump/restore-test extensions and replication topology in staging before cutover.