Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT - Mailing list pgsql-hackers

From Andrew Chernow
Subject Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT
Date
Msg-id 4BFBCEB7.7000209@esilo.com
Whole thread Raw
In response to Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT  (Alex Goncharov <alex-goncharov@comcast.net>)
List pgsql-hackers
On 05/25/2010 07:35 AM, Alex Goncharov wrote:
> ,--- I/Alex (Mon, 24 May 2010 12:25:18 -0400) ----*
> | No equivalent of FETCH_COUNT is available at the libpq level, so I
> | assume that the interface I am using is smart enough not to send
> | gigabytes of data to FE.
> |
> | Where does the result set (GBs of data) reside after I call
> | PQexecPrepared?  On BE, I hope?
>
> Sorry for asking again...
>
> No sarcasm meant: is there no straightforward answer here?  Or nobody
> is certain?  Or a wrong list?
>

Issue multiple queries and make use of LIMIT/OFFSET.  You'll have to go 
manual on this one.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_upgrade docs
Next
From: Stephen Frost
Date:
Subject: Re: ExecutorCheckPerms() hook