Here Comes Async I/O! | Scaling Postgres 365

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/365-here-comes-async-io/ In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/ Timestamps: 00:33 - PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 Released! 02:13 - PostgreSQL 18 Beta 1 Released! 03:41 - Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O 10:26 - PgDog vs. PgBouncer 11:31 - synchronous_commit 13:55 - CREATE INDEX: Data types matter 15:04 - Another look into PostgreSQL CTE materialization and non-idempotent subqueries 16:10 - Anatomy of a Database Operation 16:49 - Waiting for PostgreSQL 18 – Add function to get memory context stats for processes 17:25 - Consulting Corner 19:42 - Outro #postgres #postgresql