On Sep 6, 2013, at 6:56 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Fri, Sep 6, 2013 at 8:19 AM, Tim Kane <tim.kane@gmail.com> 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