Re: Memory exhaustion on large query - Mailing list pgsql-sql

Brice André <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