PostgreSQL 18 preview – what's new?

Asynchronous I/O, query parallelism improvements, and the biggest pg_upgrade story of the year. Deep dive inside.

PostgreSQL 18 brings optimized JSON indexing and asynchronous client operations. We review the query executor optimizations and how to prepare your production databases for seamless major upgrades.

As developers, keeping up with the rapid changes in technologies, libraries, and best practices can be overwhelming. In each issue of TechForDev, we aim to filter out the noise and deliver high-value resources, benchmarks, and summaries straight to your browser.

Below, you can explore the complete, official details of this topic directly from the official developer blogs, repository notes, and documentation portals.