Re: Streaming LIBPQ? Sliding Window in LIBPQ?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Streaming LIBPQ? Sliding Window in LIBPQ?
Date: 2007-11-28 15:15:16
Message-ID: 20071128151516.GC31742@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-28 15:21:32 Re: [Re] Re: [Re] Re: Unknown winsock error 10061while dumping a big database
Previous Message Abraham, Danny 2007-11-28 15:11:07 Streaming LIBPQ? Sliding Window in LIBPQ?