Re: [PATCHES] updated patch for selecting large results sets in psql using cursors

Peter Eisentraut <peter_e(at)gmx(dot)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