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