Re: [PATCHES] updated patch for selecting large results sets in psql using cursors - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] updated patch for selecting large results sets in psql using cursors
Date
Msg-id 13798.1156787113@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] updated patch for selecting large results sets in psql using cursors  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: [PATCHES] updated patch for selecting large results sets in
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane wrote:
>> Wait a minute.  What I thought we had agreed to was a patch to make
>> commands sent with \g use a cursor.  This patch changes SendQuery
>> so that *every* command executed via psql is treated this way.

> That's what I remembered.  I don't think we want to introduce a 
> difference between ; and \g.

Have we measured the performance impact, then?  The last time I profiled
psql, GetVariable was already a hotspot, and this introduces another
call of it into the basic query loop whether you use the feature or not.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] updated patch for selecting large results sets in psql using cursors
Next
From: Tom Lane
Date:
Subject: autovacuum causing numerous regression-test failures