Sliding windows on LIBPQ
"Abraham, Danny" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <E9DE7963E5EA6546B42A979EC28B4D01368A8D8B@hou-ex-02.adprod.bmc.com> |
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 [email protected] ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match