Скачать или смотреть 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...)