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-28 17:11:33
Message-ID: 9799.1156785093@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

Wait a minute.  What I thought we had agreed to was a patch to make
commands sent with \g use a cursor.  This patch changes SendQuery
so that *every* command executed via psql is treated this way.
That's a whole lot bigger behavioral change than I think is warranted.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Zoltan BoszormenyiDate: 2006-08-28 17:12:12
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO
Previous:From: Hans-Juergen SchoenigDate: 2006-08-28 17:01:45
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO

pgsql-patches by date

Next:From: Zoltan BoszormenyiDate: 2006-08-28 17:12:12
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO
Previous:From: Hans-Juergen SchoenigDate: 2006-08-28 17:01:45
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO

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