Waiting for Postgres 17: Streaming I/O for sequential scans & ANALYZE
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
In E112 of "5mins of Postgres" we discuss streaming and vectored I/O in Postgres 17. This is an important step towards implementing asynchronous I/O in Postgres. In Postgres 17 we do not yet have asynchronous I/O, but we do see a performance benefit from what is essentially a refactoring work around the internal APIs.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Provide vectored variant of ReadBuffer() - Postgres commit by Thomas Munro
https://git.postgresql.org/gitweb/?p=...)
Provide API for streaming relation data - Postgres commit by Thomas Munro
https://git.postgresql.org/gitweb/?p=...)
"aio" directory in Postgres source
https://github.com/postgres/postgres/...
The path to using AIO in Postgres - Talk by Andres Freund at PGConf.EU 2023
https://anarazel.de/talks/2023-12-14-...
Talk recording of The path to using AIO in Postgres
• Andres Freund: The path to using AIO in po...
Streaming I/O, vectored I/O (WIP) - Mailinglist thread on pgsql-hackers
https://www.postgresql.org/message-id...)
Use streaming I/O in pg_prewarm - Postgres commit by Thomas Munro
https://git.postgresql.org/gitweb/?p=...
Use streaming I/O in ANALYZE - Postgres commit by Thomas Munro, authored by Nazir Bilal Yavuz
https://git.postgresql.org/gitweb/?p=...
Use streaming I/O in sequential scans - Postgres commit by Thomas Munro, authored by Melanie Plageman
https://git.postgresql.org/gitweb/?p=...)
Performance implications of 8K pread()s - Mailinglist thread on pgsql-performance
https://www.postgresql.org/message-id...)