TLDR Web Dev · QUICK LINKS

TUNING AIO IN POSTGRESQL 18

vondra.me12 min read

Summary from the TLDR Web Dev newsletter

When tuning the new Asynchronous I/O (AIO) feature in PostgreSQL 18, users should generally stick with the default `io_method = worker` and increase the `io_workers` setting to around 25% of the system's cores.