build1 publisher
Postgres walks all 110,659 pages of a 1.2 GB table to answer OFFSET 9999980 LIMIT 20
One dev.to benchmark on 10 million rows measures deep pagination as a full read and discard. A PostgreSQL B-tree stores keys and not ranks, so counting from the start is the only way to reach the 9,999,981st row.
Publishers:dev.to
Reality
- Evidence72
- Adoption20
- Hype gap−12
- Incentives25
- Confidence66