~postgresweekly | Issue 599 - Lots of Postgres 18 news (5)

The Draft Release Notes for Postgres 18 — Bruce Momjian has just completed his first draft of the Postgres 18 release notes in time for Beta 1. The final release is expected in September or October.

Postgres 18 Beta 1 Released — The first official look at Postgres 18 has just landed in the past few hours. The release notes paint the big picture, but PG18 is shaping up to be a solid release with faster scans and vacuuming on Linux, parallel GIN builds, virtual generated columns, OAuth support, enhanced EXPLAIN ANALYZE output and more. It's time to go and play.

[New from O’Reilly] The 2nd Edition of CockroachDB: The Definitive Guide — Learn how to build resilient, scalable apps with a Postgres-compatible distributed SQL database. Same Postgres feel—familiar tools, schema, and queries—built to scale globally, on premise or in any cloud, with native geo-data placement and low TCO.

Accelerating Disk Reads with Asynchronous I/O in Postgres 18 — The first beta release of Postgres 18 adds limited asynchronous I/O (AIO) support – something that’s been years in the making. This post explains what it is, how it works, and what it means for performance optimization.

Announcing pg_parquet v.0.4.0 — pg_parquet provides a way to export and import Parquet files directly within Postgres, without relying on third-party tools.