On Wed, Dec 17, 2025 at 2:30 PM Andres Freund <[email protected]> wrote: > Note that due to the tuple size and fillfactor in Konstantin's workload, there > will be one tuple per page... That should allow for some prefetching.
I don't see how, unless he also set leaf fillfactor very low (though probably not even then, with LIMIT 1, since you still get a few index tuples on each leaf page). As Tomas points out, this particularly heuristic probably has some problems. I'm not claiming that this is the ideal behavior. Just that it would seem to make it almost impossible for prefetching to ever show benefits, with a workload such as this (in particular with LIMIT 1 it seems quite impossible). -- Peter Geoghegan
