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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] updated patch for selecting large results sets in psql using cursors
Дата
Msg-id 13798.1156787113@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] updated patch for selecting large results sets in psql using cursors  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: [PATCHES] updated patch for selecting large results sets in
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCHES] updated patch for selecting large results sets in psql using cursors
Следующее
От: Tom Lane
Дата:
Сообщение: autovacuum causing numerous regression-test failures