Glossary: PostgreSQL for Developers
keyset paging
Also written: LIMIT, OFFSET
A way to page through results by remembering the last key (WHERE order_id > ...) instead of using a large OFFSET, which still reads the skipped rows. LIMIT sets how many rows to return and OFFSET how many to skip.