News Score: Score the News, Sort the News, Rewrite the Headlines

Waiting for Postgres 17: Streaming I/O for sequential scans & ANALYZE

In today’s 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. In this episode, I give you a little bit of a behind the scenes view on my understanding of the changes made in 17 and how they impact future asynchronous I/O work. Share t...

Read more at pganalyze.com

© News Score  score the news, sort the news, rewrite the headlines