Why My Pagination Got Slower Every Page: Field Notes on OFFSET, Keyset Cursors, and Stable Sort Keys 56512c

Headline: OFFSET pagination tells PostgreSQL to read every row it skips and then throw those rows away, so deep pages get steadily slower and can silently skip or duplicate results while the table is