| 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 |
| Views: | Whole Thread | Raw Message | 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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zoltan Boszormenyi | 2006-08-28 17:12:12 | Re: [HACKERS] Performance testing of COPY (SELECT) TO |
| Previous Message | Hans-Juergen Schoenig | 2006-08-28 17:01:45 | Re: [HACKERS] Performance testing of COPY (SELECT) TO |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zoltan Boszormenyi | 2006-08-28 17:12:12 | Re: [HACKERS] Performance testing of COPY (SELECT) TO |
| Previous Message | Hans-Juergen Schoenig | 2006-08-28 17:01:45 | Re: [HACKERS] Performance testing of COPY (SELECT) TO |