PostgreSQL 18 was released in September 2025, and it’s packed with major improvements across the board. As of February 2026, the latest point release is PostgreSQL 18.3 — an out-of-cycle release on February 26th that fixes several regressions from the last update. Here are the highlights of the 18.x series.

Performance

• New asynchronous I/O subsystem (AIO) delivers up to 3x faster data reads
• Better index usage and parallel GIN index builds
• Skip scans on multicolumn indexes
• Improved OR condition optimization
• Faster hash/merge joins

Upgrades

• Planner statistics preserved across major upgrades — faster recovery of query performance
• pg_upgrade improvements: parallel checks, --swap option

Developer Features

• Virtual generated columns (now the default)
• UUIDv7 function — timestamp-ordered UUIDs
• Access to OLD/NEW values in RETURNING
• Temporal constraints (WITHOUT OVERLAPS, PERIOD)

Text Processing

• Faster Unicode collation (PG_UNICODE_FAST)
• Nondeterministic LIKE support
• Improved full text search behavior

Security & Authentication

• OAuth 2.0 authentication support
• FIPS mode validation
• TLS v1.3 ciphers now configurable
• MD5 auth deprecated — SCRAM recommended

Replication

• Default parallel streaming for subscriptions
• Conflict reporting
• Auto-drop idle replication slots

Maintenance & Observability

• Smarter vacuum freezing
• EXPLAIN now shows buffer, index, CPU, and WAL stats
• Expanded monitoring views

Other Notable Changes

• Page checksums enabled by default in new clusters
• New wire protocol version 3.2 — the first update since 2003!

Point Releases

• 18.1 (Nov 2025) — first maintenance release
• 18.2 (Feb 2026) — regular update cycle
• 18.3 (Feb 26, 2026) — out-of-cycle fix for regressions in 18.2

The AIO subsystem alone makes the upgrade worthwhile for anyone running read-heavy workloads. If you’re still on 17.x, now is a great time to plan the migration — 18.3 is stable and battle-tested. More details at postgresql.org.