Re: [GENERAL] select and count efficiency (~35 mln rows)

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

[GENERAL] select and count efficiency (~35 mln rows)

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

Re: [GENERAL] select and count efficiency (~35 mln rows)

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 >