On Sep 6, 2013, at 6:56 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > 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); what version did/does this come into effect? alan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
