Re: Streaming LIBPQ? Sliding Window in LIBPQ?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Streaming LIBPQ? Sliding Window in LIBPQ?
Дата
Msg-id 20071128151516.GC31742@svana.org
обсуждение исходный текст
Ответ на Streaming LIBPQ? Sliding Window in LIBPQ?  ("Abraham, Danny" <danny_abraham@bmc.com>)
Ответы Re: Streaming LIBPQ? Sliding Window in LIBPQ?  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-general
On Wed, Nov 28, 2007 at 09:11:07AM -0600, Abraham, Danny wrote:
> Is there a way to break the PGresult array to chuncks  Like Oracle?
>
> I mean, without changing the text of given queries,
>
> can we  somehow limit the memory consumption of a client that is using
> LIBPQ?

Use non-blocking mode to get the data in chunks. You can't easy control
the number of rows you get each time though...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Abraham, Danny"
Дата:
Сообщение: Streaming LIBPQ? Sliding Window in LIBPQ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Re] Re: [Re] Re: Unknown winsock error 10061while dumping a big database