Date: 2022-05-27
Time: 11:15–12:15
Room: Stream 1
Level: Intermediate
Learn more about developing and refining an algorithm for application storage prefetching.
Storage prefetching is a necessary component of Postgres' proposed new IO paradigm: direct and asynchronous IO. Though prefetching is already in use in limited contexts in Postgres (e.g. bitmap heap scan), without kernel readahead, Postgres must implement additional prefetching of its own.
This talk will cover the basics of storage prefetching, the process of developing and refining a prefetching algorithm, and the details of the prefetching algorithm proposed with the direct and asynchronous IO patch set.