Re: Cursors and Transactions, why?

Eric Ridge wrote:
> On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:
>> And now you know why they are so good if you don't use all rows. This
>> benefit I think goes away if you use Joe Conway's suggestion of WITH
>> HOLD.
>
> Okay, so WITH HOLD is actually materializing the entire resultset
> (sequential scan or otherwise)? If that's true, you're right, some of
> the benefits do go away.

Keep in mind that the tuplestore stays in memory as long as it fits
within sort_mem kilobytes. And you can do:

set sort_mem to <some_large_number>;

prior to COMMIT, and then

set sort_mem to default;

after COMMIT, as long as you can afford the memory use. A bit ugly, but
it might come in handy ;-)

Joe