On Fri, Sep 6, 2013 at 8:19 AM, Tim Kane <tim.kane@xxxxxxxxx> wrote: > Ahh. All these years (albeit sporadic), I never knew about FETCH_COUNT. > That makes sense. Thanks muchly. Not your fault: FETCH_COUNT is a hack IMO. The real issue was that libpq (until recently) forced the entire result into memory before it was returned to the caller. We can now in libpq (thanks Marko) that allows process rows as they come in. I expect soon psql will be adjusted to utilize that new API (although exactly how is unclear); runaway memory consumption in libpq/psql burns a *lot* of people. I personally find cursors to be baroque and rarely use them except internally inside pl/pgsql functions. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
