Please read the links below: http://www.depesz.com/2007/08/29/better-results-paging-in-postgresql-82/ https://wiki.postgresql.org/wiki/File:Pagination_Done_the_PostgreSQL_Way.pdf https://coderwall.com/p/lkcaag
I am reading the articles right now.
>There are about 35 milion records in the table.do you really want to show all records, even with pagination? REALLY?
There are different accounts and rights in the system, most offen the number of rows is narrowed down. But there is one account type, which can see that many results. And to be precise - problem appears even for the users, who are not able to access the hole table.
<<attachment: smime.p7s>>
