Re: [PATCHES] updated patch for selecting large results - Mailing list pgsql-hackers

From Chris Mair
Subject Re: [PATCHES] updated patch for selecting large results
Date
Msg-id 1156930821.2251.3.camel@ultra.home.lan
Whole thread Raw
In response to Re: [PATCHES] updated patch for selecting large results sets in psql using cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, 2006-08-29 at 18:31 -0400, Tom Lane wrote:
> <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

Cool!
I specially like that as a side effect of your work for applying this,
psql is faster now.

Thanks to all people that helped with this (lots...:)

Bye, Chris.



--

Chris Mair
http://www.1006.org


pgsql-hackers by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Status on Fedora Core Extras packaging
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Backend SSL configuration enhancement