Re: Cursors and Transactions, why? - Mailing list pgsql-general

From Eric Ridge
Subject Re: Cursors and Transactions, why?
Date
Msg-id 116AA260-88F5-11D8-91AB-000A95BB5944@tcdi.com
Whole thread Raw
In response to Re: Cursors and Transactions, why?  (Joe Conway <mail@joeconway.com>)
Responses Re: Cursors and Transactions, why?
List pgsql-general
On Apr 7, 2004, at 7:48 PM, Joe Conway wrote:

> Eric Ridge wrote:
>> Is the tuplestore basically just an array of ItemPointer-s?  In mean,
>> it's not a copy of each entire row, is it?
>
> Yup, it is copied:

wow.  I should go back and read the archives to see if this was
discussed already, but I can't help but wonder if there's a way to only
copy pointers to the tuples.  I realize VACUUM could screw it up, but
maybe something could be invented (or re-used) to help guard against
that.

eric


pgsql-general by date:

Previous
From: Eric Ridge
Date:
Subject: Re: Cursors and Transactions, why?
Next
From: Tom Lane
Date:
Subject: Re: ERROR: invalid memory alloc request size 0