Re: execute cursor fetch

Поиск
Список
Период
Сортировка
От my ho
Тема Re: execute cursor fetch
Дата
Msg-id 20041012114343.69531.qmail@web54110.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: sequential scan on select distinct  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Ответы Re: execute cursor fetch
Re: execute cursor fetch
Список 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 по дате отправления:

Предыдущее
От: Matt Clark
Дата:
Сообщение: Re: IBM P-series machines
Следующее
От: "Aaron Werman"
Дата:
Сообщение: Re: Normal case or bad query plan?