Glossary: PostgreSQL Beyond the Basics
Keyset pagination
Also written: keyset paging, OFFSET
Paging by remembering the last row shown and asking for rows after it, instead of using OFFSET. It reads exactly one page of rows on any page, whereas OFFSET reads and discards all the earlier rows.