Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT

Поиск
Список
Период
Сортировка
От Andrew Chernow
Тема Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT
Дата
Msg-id 4BFBCEB7.7000209@esilo.com
обсуждение исходный текст
Ответ на Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT  (Alex Goncharov <alex-goncharov@comcast.net>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pg_upgrade docs
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: ExecutorCheckPerms() hook