Schedule - PGConf NYC 2023

The path to using AIO in postgres

Date: 2023-10-04
Time: 11:40–12:30
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

For a few years we (Andres Freund, Thomas Munro, Melanie Plageman, David Rowley) have been working towards using asynchronous IO (AIO) and direct IO in Postgres. In this talk I'll describe what using AIO in postgres looks like, what we already have gotten into postgres (e.g. speeding up concurrent COPY by 3x in 16), what we hope to get into postgres 17, and what we hope to achieve longer term.

The goal of using AIO and DIO in postgres is to improve throughput, decrease latency, reduce jitter, reduce double buffering and more.

Slides

The following slides have been made available for this session:

Speaker

Andres Freund