Re: psql client memory usage

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