"[email protected]" <[email protected]> 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 -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
