To get the show notes as well as get notified of new episodes, visit: In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: Timestamps: 00:44 - Pipelining in psql (PostgreSQL 18) 04:39 - Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly 05:30- Postgres 18 06:16 - Going down the rabbit hole of Postgres 18 features 07:31 - Cumulative Statistics in PostgreSQL 18 08:09 - What's New in PostgreSQL 18 - a Developer's Perspective 08:33 - PostgreSQL 18 and beyond: From AIO to Direct IO? 10:14 - Waiting for PostgreSQL 19 – Add GROUP BY ALL. 10:45 - How to do UPDATE ... LIMIT in PostgreSQL 12:11 - How I learned to use wal_inspect 12:54 - Consulting Corner 14:44 - Outro #postgres #postgresql