Re: Cursor behavior

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Cursor behavior
Дата
Msg-id CA+TgmoYtd_mOgs346+z74MtHjKGXn_sseGORFYGNZH3ht2QHfg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cursor behavior  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Dec 21, 2011 at 11:44 AM, amit sehas <cun23@yahoo.com> wrote:
> It seems that the task of fetching next n results without moving the cursor seems like too complicated to implement
forany query that has
 
> even a little bit of complication in it...

I think that's probably true.  It would also be expensive if you did
implement it; who wants to go re-execute a join to back up the scan?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Cursor behavior
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CLOG contention