Re: BUG #7918: limitation of pagination with LIMIT and OFFSET

"adrianopatrick@gmail.com" <adrianopatrick@gmail.com> wrote:

> I need to process a query, the query returned as somewhere around
> 20 million records, I thought to do with LIMIT and OFFSET where
> the limit is fixed for 5000 records and will incrementing the
> OFFSET, but when reached OFFSET 400 000 consultation was very
> slow, taking almost the time of the query without LIMIT and
> OFFSET.

You should probably use a cursor instead of LIMIT and OFFSET.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company