Re: Cursors and Transactions, why?

<wespvp@syntegra.com> writes:
> On 4/6/04 3:55 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>> In theory at least, that should not be any faster than a WITH HOLD
>> cursor, since you're effectively replicating the same functionality
>> outside the database ...

> Except for the "out of memory" thing...

What "out of memory thing"?  The tuplestore code is perfectly capable of
spilling to disk --- in fact the usual performance gripe against it has
to do with spilling too soon, because sort_mem is set too small.

            regards, tom lane