Raj Shooj-Q16466 <shooj(at)motorola(dot)com> writes:
> I am retrieving 1 million records by executing the sql query
> SELECT * FROM myTable ORDER BY sub_id LIMIT 20000 OFFSET <num>;
> in a loop, incrementing <num> every time by 20000.
Wouldn't it be better to use a cursor?
BEGIN;
DECLARE c CURSOR FOR SELECT * FROM myTable ORDER BY sub_id;
FETCH 20000 FROM c;
... repeat FETCH as needed ...
COMMIT;
regards, tom lane