We might rephrase OP's idea to asking whether the btree pager could usefully send `posix_fadvise(..., POSIX_FADV_WILLNEED, ...)` through the VFS. I doubt it, for the reasons I've elaborated, but it seems to me a reasonable concept in fact implemented by a lot of databases.