PostgreSQL 9.2 has a new feature that allows results sets to be returned row by row instead of the whole result set at once.
This is a huge improvement for larger result sets.
See here for more info:
http://www.postgresql.org/docs/9.2/static/libpq-single-row-mode.html