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

Re: updated patch for selecting large results sets in psql using cursors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org, chrisnospam(at)1006(dot)org
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: updated patch for selecting large results sets in psql using cursors
Date: 2006-08-29 22:31:24
Message-ID: 18251.1156890684@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
<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

In response to

Responses

pgsql-hackers by date

Next:From: mario tovillaDate: 2006-08-29 22:41:18
Subject: I need your help!!
Previous:From: Bruce MomjianDate: 2006-08-29 22:12:54
Subject: Re: [HACKERS] Interval aggregate regression failure

pgsql-patches by date

Next:From: Michael GlaesemannDate: 2006-08-30 01:30:43
Subject: Re: [HACKERS] Interval aggregate regression failure (expected seems
Previous:From: Bruce MomjianDate: 2006-08-29 22:12:54
Subject: Re: [HACKERS] Interval aggregate regression failure

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