Guys behinds PostgreSQL / CitusDB wrote awesome article on which methods of pagination work how well and where they fail. https://www.citusdata.com/blog/2016/0

Guys behinds PostgreSQL / CitusDB wrote awesome article on which methods of pagination work how well and where they fail. https://www.citusdata.com/blog/2016/03/30/five-ways-to-paginate/ https://www.citusdata.com/blog/2016/03/30/five-ways-to-pagin... Highly recommended read.