Thread: Streaming processing of result sets

Streaming processing of result sets

From
Florian Weimer
Date:
Unless you use COPY, libpq loads the complete query result into
memory.  In some cases, this is not desirable.  I know that with
non-MVCC databases, it is important to load the result from the
database server in a non-blocking fashion because you can easily stall
other transactions or even deadlock if you block during result
processing (waiting for another network connection, for instance).  Is
this true for PostgreSQL as well, or can clients block without causing
too much trouble?

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99