| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | matshyeq <matshyeq(at)gmail(dot)com> |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "Daniel Verite *EXTERN*" <daniel(at)manitou-mail(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: libpq - lack of support to set the fetch size |
| Date: | 2014-03-10 15:16:24 |
| Message-ID: | 908.1394464584@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
matshyeq <matshyeq(at)gmail(dot)com> writes:
> If 'SingleRowMode' goes row-by-row then again it's not a solution,
> especially given that this particular issue applies to rather large row
> sets.
Perhaps you should actually experiment with that solution instead of
rejecting it out of hand. Or at least RTFM about it.
It does have limitations: you can't interleave fetching of different
large query results. But I don't have a problem telling people they
ought to use cursors for such cases.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-03-10 15:19:57 | Re: libpq - lack of support to set the fetch size |
| Previous Message | Tom Lane | 2014-03-10 15:10:14 | Re: Playing with 9.4devel - unnest |