Re: updated patch for selecting large results sets in psql using cursors - Mailing list pgsql-patches

From Tom Lane
Subject Re: updated patch for selecting large results sets in psql using cursors
Date
Msg-id 9799.1156785093@sss.pgh.pa.us
Whole thread Raw
In response to updated patch for selecting large results sets in psql using cursors  (<chrisnospam@1006.org>)
Responses Re: updated patch for selecting large results sets in psql using cursors  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
<chrisnospam@1006.org> writes:
> here comes the latest version (version 7) of the patch to handle large
> result sets with psql.  As previously discussed, a cursor is used
> for SELECT queries when \set FETCH_COUNT some_value > 0

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 a whole lot bigger behavioral change than I think is warranted.

            regards, tom lane

pgsql-patches by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO
Next
From: Zoltan Boszormenyi
Date:
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO