Postgres Pro
Downloads
Home   >   mailing lists

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

From Abraham, Danny
Subject Streaming LIBPQ? Sliding Window in LIBPQ?
Date
Msg-id E9DE7963E5EA6546B42A979EC28B4D01368A8E18@hou-ex-02.adprod.bmc.com
Whole thread Raw
Responses Re: Streaming LIBPQ? Sliding Window in LIBPQ?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view

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?

 

 The API is ...

 

 extern PGresult *PQexec(PGconn *conn, const char *query);

 

 Is there any "SLiding Window" layer that breaks the PGresult into chuncks?

 

 Big queries take a lot more memory on the client side compared to other DB  clients.

 

 Thanks

 

 Danny

 

 

 

Danny Abraham

BMC Software

CTM&D Business Unit

972-52-4286-513

danny_abraham@bmc.com

 

pgsql-general by date:

Previous
From: Peter Bauer
Date:
Subject: Re: System Load analyze
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Streaming LIBPQ? Sliding Window in LIBPQ?