Re: Cursor behavior

On Thu, Dec 15, 2011 at 4:15 PM, amit sehas <cun23@yahoo.com> wrote:
> I had a question about the cursor internals implementation. When you Fetch next 'n' results without moving the
cursors,is this kind of functionality implemented by firstly executing the whole query and then moving the cursor over
theresults, or are the movements done on active database lookups, moving forward and backward... 

I think it depends on the query.  For example, I believe that a query
involving writeable CTEs will be run to completion before returning
any results, but I believe that a seqscan will not.

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