{"podcast":{"title":"The Backend Engineering Show with Hussein Nasser","slug":"the-backend-engineering-show-with-hussein-nasser-847440","podcast_index_feed_id":847440,"rss_url":"https://anchor.fm/s/1eb6d14/podcast/rss","website_url":"https://database.husseinnasser.com","image_url":"https://d3t3ozftmdmh3i.cloudfront.net/production/podcast_uploaded_nologo/222061/222061-1626111277047-d82a050054721.jpg","author":"Hussein Nasser","episode_count":541,"summary":"Welcome to the Backend Engineering Show podcast with your host Hussein Nasser. If you like software engineering you’ve come to the right place. I discuss all sorts of software engineering technologies and news with specific focus on the backend. All opinions are my own. Most of my content in the podcast is an audio version of videos I post on my youtube channel here http://www.youtube.com/c/HusseinNasser-software-engineering Buy me a coffee https://www.buymeacoffee.com/hnasr 🧑‍🏫 Courses I Teach https://husseinnasser.com/courses","last_synced_at":"2026-07-11T00:20:07.790472+00:00","page_url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440"},"episode":{"title":"Postgres 18 gets Async IO","slug":"postgres-18-gets-async-io","published_at":"2025-10-03T14:00:00+00:00","page_url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/postgres-18-gets-async-io","show_page_url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440","url":"https://podcasters.spotify.com/pod/show/hnasr/episodes/Postgres-18-gets-Async-IO-e38st84","audio_url":"https://anchor.fm/s/1eb6d14/podcast/play/108999364/https%3A%2F%2Fd3ctxlq1ktw2nl.cloudfront.net%2Fstaging%2F2025-8-30%2F67a02205-bc51-6259-8495-97f7ac2eae3a.m4a","summary":"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","meta_description":"Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynch…","key_points":[],"chapters":[],"topics":[],"duration_seconds":2472,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/the-backend-engineering-show-with-hussein-nasser-847440/episodes/postgres-18-gets-async-io/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/postgres-18-gets-async-io.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}