Skip to content

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.

Where the book teaches it

Related terms

Row comparisonSargable