On Sunday, December 6, 2020, 孙冰 <subi.the.dream.wal...@gmail.com> wrote:
> The skipped rows by an OFFSET clause have to be computed nevertheless. I > am wondering if there could be any chance to improve, since the computation > is on the *entire* rows rather than on the *criterial* columns. > > [...] > > I don't understand the postgresql internal, but I suspect such a change > may introduce significant work on the planner and executor. From my point > view, skipping everything (or expensive ones) except the criteria in the > target list would greatly improve the usability of OFFSET, and it is > definitely worth the effort. > Given that one can write this with a subquery without much difficulty i’m doubtful that effort spent in this area is going to be particularly valuable. David J.
