Pagination記録

Keyset pagination vs OFFSET in PostgreSQL

OFFSET reads and discards every row it skips, and silently duplicates records when data shifts. Keyset pagination fixes both, at a price worth knowing.