Re: Queries with large ResultSets

Dave Cramer wrote:
> There's some confusion as to whether a cursor is materialized even
> inside a transaction. It could be that complicated queries will be
> stored on the disk too.

The docs cover this. Executive summary: SCROLL cursors might be more
expensive than NO SCROLL cursors, depending on the query. It's a
separate issue to WITH HOLD / WITHOUT HOLD as far as I know.

http://www.postgresql.org/docs/7.4/static/sql-declare.html

-O