Postgres 18 Released! | Scaling Postgres 385

In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more!

Content Discussed

• PostgreSQL 18 Released!
• PostgreSQL 18: Better I/O performance with AIO
• Tuning AIO in PostgreSQL 18
• What went wrong (& what went right) with AIO with Andres Freund
• PostgreSQL: "UPDATE … RETURNING" made even better
• Postgres 18: OLD and NEW Rows in the RETURNING Clause
• Parallel Apply of Large Transactions
• Changes to NOT NULL in Postgres 18
• UUIDv7 Comes to PostgreSQL 18
• Gadget's use of Postgres
• Celebrating the PostgreSQL 18 Release
• What are SLRUs and MultiXacts in Postgres? What can go wrong?
• PlanetScale for Postgres is now GA
• Postgres Partitioning Best Practices: Sofia's Story
• What Unicode versions do we use?
• PGDay Lowlands 2025 and Getting Postgres to the Next Level
• Writing nothing but docs for a week
• Postgres’ Original Project Goals: The Creators Totally Nailed It
• Understanding PostgreSQL WAL and optimizing it with a dedicated disk
• Contributions for the week 38
• PostgreSQL 18: part 5 or CommitFest 2025-03
• PgPedia Week, 2025-09-14
• PostgreSQL at the Zoo – My PGDay Lowlands 2025 Recap
• What's new in PostgreSQL 18 RPMs, and EDB's contribution to PostgreSQL RPM packaging
• SkipScan in TimescaleDB: Why DISTINCT Was Slow, How We Built It, and How You Can Use It
• Postgres 18 Is Out: Try it on Neon
• Migrate full-text search from SQL Server to Amazon Aurora PostgreSQL-compatible edition or Amazon RDS for PostgreSQL

YouTube Video

Podcast Audio