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 ta
Grzegorz Kuczera wrote:
> This is my first question here, so I would like to say hello to everyone:)
>
> In my case, the problem appears when I want to fetch some data to inflate the
> table with it. First of all, I am counting the records from the table (for
> paging, over indexed column), then
This is my first question here, so I would like to say hello to everyone:)
In my case, the problem appears when I want to fetch some data to
inflate the table with it. First of all, I am counting the records from
the table (for paging, over indexed column), then the select query is
performed (