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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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