=?UTF-8?B?QnJpY2UgQW5kcsOp?= <brice@famille-andre.be> writes:
> The content of the table is so huge that, if PQsendQueryPrepared retrieves
> all data, or if postgresql engine is creating temp file with all data, the
> query cannot succeed (I have no enough RAM or disk space to copy the whole
> data). But I was expecting that using PQsendQueryPrepared and PQgetResult
> would avoid this by returning one result at a time.
You're confusing asynchronous mode with single-row mode. Async mode,
per se, doesn't change memory consumption; it just lets you do something
else while waiting for the query result. You are (I suppose) missing
a call to PQsetSingleRowMode --- see
https://www.postgresql.org/docs/current/libpq-single-row-mode.html
regards, tom lane