To get the show notes as well as get notified of new episodes, visit: 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! Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: Timestamps: 00:30 - PostgreSQL 18 Released! 04:16 - PostgreSQL 18: Better I/O performance with AIO 07:21 - Tuning AIO in PostgreSQL 18 10:14 - What went wrong (& what went right) with AIO with Andres Freund 10:29 - PostgreSQL: "UPDATE … RETURNING" made even better 11:40 - Postgres 18: OLD and NEW Rows in the RETURNING Clause 12:21 - Parallel Apply of Large Transactions 13:25 - Changes to NOT NULL in Postgres 18 14:28 - UUIDv7 Comes to PostgreSQL 18 14:59 - Gadget's use of Postgres 16:49 - Outro #postgres #postgresql