Re: Cursor behavior

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: amit sehas <cun23(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Cursor behavior
Date: 2011-12-21 16:46:49
Message-ID: CA+TgmoYtd_mOgs346+z74MtHjKGXn_sseGORFYGNZH3ht2QHfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Dec 21, 2011 at 11:44 AM, amit sehas <cun23(at)yahoo(dot)com> wrote:
> It seems that the task of fetching next n results without moving the cursor seems like too complicated to implement for any 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-12-21 16:48:23 Re: CLOG contention
Previous Message amit sehas 2011-12-21 16:44:59 Re: Cursor behavior