PostgreSQL traditionally has handled IO in a fairly minimal way, relying on the operating system more than most other databases. This talk will discuss why PostgreSQL mostly got away with that so far, why current hardware trends (NVMe with very high bandwidth / low latency, cloud storage with high latency but​ good random / concurrent read behaviour) require changing course and the path towards modernizing the IO stack in PostgreSQL to use asynchronous / direct IO.

This talk is part of the Vaccination Database (Booster) Tech Talk Seminar Series.

Bio:
Andres Freund is a long-time Postgres Developer, Committer and Core Team member. He has worked on many aspects of Postgres, including logical decoding, scalability, pluggable table storage, query execution performance, bugfixing and patch review. He works for Microsoft, doing open source PostgreSQL development.

More Info: https://db.cs.cmu.edu/seminar2022-booster#db14