Open Vanuan opened 8 years ago
http://www.postgresql.org/docs/8.3/static/queries-limit.html
The rows skipped by an OFFSET clause still have to be computed inside the server; therefore a large OFFSET might be inefficient.
http://chrisdone.com/posts/postgresql-pagination http://blog.clearbit.com/postgres-offsets/ http://stackoverflow.com/questions/31886150/postgresql-pagination http://stackoverflow.com/questions/6618366/improving-offset-performance-in-postgresql
http://www.postgresql.org/docs/8.3/static/queries-limit.html
http://chrisdone.com/posts/postgresql-pagination http://blog.clearbit.com/postgres-offsets/ http://stackoverflow.com/questions/31886150/postgresql-pagination http://stackoverflow.com/questions/6618366/improving-offset-performance-in-postgresql