>> The best solution is probably to put a LIMIT into the DECLARE CURSOR,
>> so that the planner can see how much you intend to fetch.
I assume that this limits the resultset to a LIMIT. That is not what I was 
hoping for. I was hoping for a way to scrolll throught the whole tables with 

I have tested, and if one really wants the whole table the query with "set 
enable_seqscan = on" lasts 137 secs, the query with "set enable_seqscan = off" 
lasts 473 secs, so (alas), the planner is right. 

I sure would like to have ISAM like behaviour once in a while.


Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to