Re: Streaming LIBPQ? Sliding Window in LIBPQ? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Streaming LIBPQ? Sliding Window in LIBPQ?
Date
Msg-id 20071128151516.GC31742@svana.org
Whole thread Raw
In response to Streaming LIBPQ? Sliding Window in LIBPQ?  ("Abraham, Danny" <danny_abraham@bmc.com>)
Responses Re: Streaming LIBPQ? Sliding Window in LIBPQ?  (Gregory Stark <stark@enterprisedb.com>)
List 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

Attachment

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Streaming LIBPQ? Sliding Window in LIBPQ?
Next
From: Tom Lane
Date:
Subject: Re: [Re] Re: [Re] Re: Unknown winsock error 10061while dumping a big database