Postgres OFFSET vs keyset: page 100,000 is 6,000x slower
Keyset pagination is 6,000x faster than OFFSET at page 100,000 of a 5-million-row Postgres table. In our lab, LIMIT 20 OFFSET 1999980 took 182 ms, while the keyset query for the same page took 0.03
Wed Oct 21 2026 · 11 min read · 0 views