Re: Cursors and Transactions, why?

From: Eric Ridge <ebr(at)tcdi(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Pgsql-General <pgsql-general(at)postgresql(dot)org>, Jan Wieck <JanWieck(at)Yahoo(dot)com>
Subject: Re: Cursors and Transactions, why?
Date: 2004-04-08 00:38:34
Message-ID: 116AA260-88F5-11D8-91AB-000A95BB5944@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-04-08 01:29:06 Re: ERROR: invalid memory alloc request size 0
Previous Message Eric Ridge 2004-04-08 00:36:20 Re: Cursors and Transactions, why?