Skip to content

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.

Where the book teaches it

Related terms

index