Re: Cursor behavior - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Cursor behavior
Date
Msg-id CA+TgmoYtd_mOgs346+z74MtHjKGXn_sseGORFYGNZH3ht2QHfg@mail.gmail.com
Whole thread Raw
In response to Re: Cursor behavior  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Cursor behavior
Next
From: Tom Lane
Date:
Subject: Re: CLOG contention