Re: select and count efficiency (~35 mln rows) - Mailing list pgsql-general

> 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.