Wagner Bianchi has submitted a new session! PostgreSQL 18 and Asynchronous I/O: An Architectural Leap Toward Modern Data Workloads PostgreSQL 18 introduces the first foundational integration of asynchronous I/O (async I/O) into the ecosystem, marking a historic shift in how PostgreSQL interacts with modern Linux storage subsystems. This paper explains the architectural changes behind adopting io_uring, the modern kernel asynchronous I/O framework introduced in Linux 5.1. We will explore how PostgreSQL now leverages memory-mapped shared ring buffers (Submission Queue and Completion Queue) to minimize syscall overhead, reduce latency, and unlock higher parallelism during disk operations. The paper will also cover how PostgreSQL’s shared buffer architecture complements asynchronous I/O, and will compare PostgreSQL’s conservative gradual adoption strategy to other RDBMS engines such as MySQL/InnoDB and Oracle Database. Practical examples, early benchmarking scenarios, and operational tuning recommendations for PostgreSQL 18 on XFS with io_uring will be presented. This hands-on, system-oriented guide will help engineers, DBAs, and cloud architects understand what to expect from asynchronous I/O in PostgreSQL and how to prepare for its maturation in PostgreSQL 19 and beyond. Open session [https://sessionize.com/app/organizer/session/19661/931230] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***@***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK