Re: execute cursor fetch - Mailing list pgsql-performance

From my ho
Subject Re: execute cursor fetch
Date
Msg-id 20041012114343.69531.qmail@web54110.mail.yahoo.com
Whole thread Raw
In response to Re: sequential scan on select distinct  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Responses Re: execute cursor fetch
Re: execute cursor fetch
List pgsql-performance
Hi,
If anyone can help pls, I have a question abt the
execution of cursor create/fetch/move , in particular
about disk cost. When a cursor is created, is the
whole table (with the required columns) got put into
memory? otherwise how does it work? (in term of disk
read and transfer?) after user issues command
move/fetch, how does postgre speed up the query in
compare to normal selection?
Thanks a lot,
regards,
MT Ho




__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

pgsql-performance by date:

Previous
From: Matt Clark
Date:
Subject: Re: IBM P-series machines
Next
From: "Aaron Werman"
Date:
Subject: Re: Normal case or bad query plan?