Re: execute cursor fetch
От | Pierre-Frédéric Caillaud |
---|---|
Тема | Re: execute cursor fetch |
Дата | |
Msg-id | opsfrbykrycq72hf@musicbox обсуждение исходный текст |
Ответ на | Re: execute cursor fetch (my ho <mthoatbanjo@yahoo.com>) |
Ответы |
Re: execute cursor fetch
|
Список | pgsql-performance |
I just discovered this : http://www.postgresql.org/docs/7.4/static/jdbc-query.html#AEN24298 On Tue, 12 Oct 2004 04:43:43 -0700 (PDT), my ho <mthoatbanjo@yahoo.com> wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-performance по дате отправления: