Retrieving Query Results Row-By-Row
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
14
votes
![](https://secure.gravatar.com/avatar/23b65662d899728efe8b842ac4906aca?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)