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

From
Subject updated patch for selecting large results sets in psql using cursors
Date
Msg-id 17911.193.206.186.101.1156775378.squirrel@www.endian.it
Whole thread Raw
Responses Re: updated patch for selecting large results sets in psql using cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: updated patch for selecting large results sets in psql using cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Hi there,

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
(defaults to 100 if FETCH_COUNT is set with no value).

Comparing to the previous version, the patch actually got smaller and is
less invasive, because I doesn't have to deal with a new command and
can share some more code with SendQuery() in common.c.

Bye,
Chris.


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



Attachment

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Trivial patch to double vacuum speed on tables with no indexes
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO