Re: psql large RSS (1.6GB) - Mailing list pgsql-performance

From Tom Lane
Subject Re: psql large RSS (1.6GB)
Date
Msg-id 14203.1099324987@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql large RSS (1.6GB)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: psql large RSS (1.6GB)  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> No, I don't remember hearing this discussed and I don't think most
> people would want libpq spilling to disk by default.

Far more useful would be some sort of streaming API to let the
application process the rows as they arrive, or at least fetch the rows
in small batches (the V3 protocol supports the latter even without any
explicit use of a cursor).  I'm not sure if this can be bolted onto the
existing libpq framework reasonably, but that's the direction I'd prefer
to go in.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql large RSS (1.6GB)
Next
From: "Anjan Dave"
Date:
Subject: shared_buffers and Shared Memory Segments