Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] updated patch for selecting large results

From: Chris Mair <chrisnospam(at)1006(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] updated patch for selecting large results
Date: 2006-08-30 09:40:20
Message-ID: 1156930821.2251.3.camel@ultra.home.lan (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Tue, 2006-08-29 at 18:31 -0400, Tom Lane wrote:
> <chrisnospam(at)1006(dot)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


In response to

pgsql-hackers by date

Next:From: Victor B. WagnerDate: 2006-08-30 12:28:59
Subject: Backend SSL configuration enhancement
Previous:From: Devrim GUNDUZDate: 2006-08-30 09:12:30
Subject: Status on Fedora Core Extras packaging

pgsql-patches by date

Next:From: Victor B. WagnerDate: 2006-08-30 12:28:59
Subject: Backend SSL configuration enhancement
Previous:From: Michael MeskesDate: 2006-08-30 08:28:54
Subject: Re: Changes to epgc test

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group