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 18251.1156890684@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: [HACKERS] updated patch for selecting large results
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

Applied with revisions ... I didn't like the fact that the code was
restricted to handle only unaligned output format, so I fixed print.c
to be able to deal with emitting output in sections.  This is not
ideal for aligned output mode, because we compute column widths
separately for each FETCH group, but all the other output modes work
nicely.  I also did a little hacking to make \timing and pager output
work as expected.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Interval aggregate regression failure
Next
From: Michael Glaesemann
Date:
Subject: Re: [HACKERS] Interval aggregate regression failure (expected seems