Citus Data Blog company blog
Ways to paginate in Postgres (2016)
Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as well as more exotic techniques.
- Points
- 186
- HN comments
- 46
- Submissions
- 1
- Cited by
- 10 commenters
Databases & DataSoftware Engineering2017
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Oct 11, 2017 | Ways to paginate in Postgres (2016) by ligistic | 186 | 46 |
Cited in comments
Linked from 10 Hacker News comments by 10 different people, from Feb 2017 to May 2023.
Most recent:
- kdmytro · May 19, 2023
- nextaccountic · Aug 21, 2022
- e12e · Aug 16, 2022
- alexvoda · Apr 17, 2021
- felixhuttmann · Jan 3, 2021
- felixyz · Dec 20, 2019
