Streaming processing of result sets

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(at)bfk(dot)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