...

1. Front-end side:
   1. remove offset from query
   2. take last result from previous page and pass parameters(parameters that is used for sort) from it to query for the next page
2. Back-end side:
   1. remove offseting
   2. add filtering for parameters that is used for ordering

SQL example(fetch second page):

Conclusion

This page was created to introduce seek method over regular offset pagination  in Postgres.

...