Offset doesn't work with subqueries?

Question

PostgreSQL

I use postgres, when paging with offset and limit, and using subqueries, with an increase in the number of offset
, the execution time increases very much. I understand that he first calculates for the entire subselect table, then only makes a selection?

There are no sorting and conditions in the request

Answer 1

No need to use a large offset. Everything. In any DBMS.
https://use-the-index-luke.com/no-offset
https://use-the-index-luke.com/sql/partial-results...