AIO performance - now and in the future
October 20–23
Level: Intermediate
PostgreSQL supports AIO since version 18, and it's gradually adopting it in more and more places. Let's talk about the performance impact you should expect, tuning the various configuration options, and the pros/cons etc.
I'll briefly explain the overall AIO architecture, and the expected benefits. Then we'll go over the main configuration options - their purpose and tuning them, with the various trade offs. During the talk I'll present various benchmarks, to illustrate the points.
This is a talk about internals / PostgreSQL feature, but it's intended for PostgreSQL users / DBAs.
