On Tue, 31 Dec 2024 at 06:24, Ayush Vatsa <ayushvatsa1...@gmail.com> wrote: > To me, using a range of pages to prewarm a relation doesn’t seem like a > common use case. For example, if a user calls prewarm(100, 200), > how would they decide those specific numbers? While it’s possible to > inspect the contents of those pages, as Jeremy noted, users typically > don’t track the location of specific rows for prewarming purposes.
It's probably rarely useful for that exact reason, however, for insert-only tables (where only recently inserted data is queried), which pages recently inserted rows are in is more predictable. I can imagine that someone might want to load some recent percentage of the table using these parameters. David
