Re: selecting large result sets in psql using - Mailing list pgsql-hackers

From
Subject Re: selecting large result sets in psql using
Date
Msg-id 25649.193.206.186.101.1156775717.squirrel@www.endian.it
Whole thread Raw
In response to Re: [PATCHES] selecting large result sets in psql using  (<chrisnospam@1006.org>)
List pgsql-hackers
>>> To cut the Gordon knot I'm going to suggest we use:
>>
>>> \set CURSOR_FETCH fetch_count
>>
>>> and \g and ; are modified such that when they see
>>> this variable set to fetch_count > 0 and the buffer
>>> is a select they would use the modified fetch/output code.
>>
>>> Does this sound reasonable to everyone?
>>
>> OK with me, but maybe call the variable FETCH_COUNT, to avoid the
>> presupposition that the implementation uses a cursor.  As I mentioned
>> before, I expect we'll someday rework it to not use that.
>>
>>             regards, tom lane
>
> Ok,
> sounds good.
> I'm travelling this week, but can send an updated patch during the
> weekend.

I've just submitted an updated patch to pgsql-patches in a new
thread :)


Bye,
Chris.


-- 
Chris Mair
http://www.1006.org






pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCHES] Trivial patch to double vacuum speed on tables with no indexes
Next
From: Tom Lane
Date:
Subject: Re: Rtree circle ops