Conference Schedule - PGCon 2022

Developing Postgres' Prefetching Algorithm

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.

Speaker

Melanie Plageman