# Postgres 18 gets Async IO

Page: https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/postgres-18-gets-async-io
Text version: https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/postgres-18-gets-async-io.md
Podcast: [The Backend Engineering Show with Hussein Nasser](https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440)
Published: 2025-10-03T14:00:00+00:00
Episode link: https://podcasters.spotify.com/pod/show/hnasr/episodes/Postgres-18-gets-Async-IO-e38st84
Audio file: https://anchor.fm/s/1eb6d14/podcast/play/108999364/https%3A%2F%2Fd3ctxlq1ktw2nl.cloudfront.net%2Fstaging%2F2025-8-30%2F67a02205-bc51-6259-8495-97f7ac2eae3a.m4a
Processing state: not_requested
JSON: https://stenobird.com/v1/public/podcasts/the-backend-engineering-show-with-hussein-nasser-847440/episodes/postgres-18-gets-async-io
Duration seconds: 2472

## Resource

Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it 0:00 Intro 1:30 Synchronous vs Asynchronous calls 3:00 Synchronous IO 6:30 Asynchronous IO 10:00 Postgres 17 synchronous io 17:20 The challenge of Async IO in Postgres 18 20:00 io_method worker23:00 io_method io_uring 29:30 io_method sync 31:08 Async IO isn’t done! 3 1:30 Support for backend writers 32:36 Improve worker io_method 33:00 direct io support 37:00 Summary

## Actions

- request_transcript: `POST https://stenobird.com/v1/public/podcasts/the-backend-engineering-show-with-hussein-nasser-847440/episodes/postgres-18-gets-async-io/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/postgres-18-gets-async-io.md` — Read the agent-friendly Markdown representation of this episode resource.

A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed.

## Transcript

Full transcripts are not published on public pages unless there is a clear rights basis.