Limit PhisicalIO from pre-fetching beyond the Row Group boundary when reading Parquet

[oleg-lvovitch-aws]

Tell us more about this new feature.

This idea is courtesy @ahmarsuhail.
Today PhisicalIO expands the read window based on the prior sequential read patterns. This is sensible, however when reading Parquet, pre-fetching past the boundary of a RG or a footer (for which there should be no prefetching anyway) never makes sense.
Given that we already know the size of the RG in LogicalIO, we know the upper boundary on the prefetch, reducing over-reads.
The strawman of the approach: Phisical IO allows upper bound specification for each request, and Parquet Logical IO passes it on relevant fetches.

Code of Conduct

• I agree to follow this project's Code of Conduct