Re: Query memory usage

Tom Duffey <tduffey@trillitech.com> writes:
> On May 15, 2010, at 4:51 PM, Tom Lane wrote:
>> What's being done on the client side with the data?

> I am executing the query in psql at the command line and piping the
> result to a file, e.g.,
> psql < get_data.sql > data.sql

Well, I tried executing a large "copy (select ...)" query and couldn't
see any memory bloat at all in either the backend or psql.  So there's
something relevant that you haven't told us.

Could we see the full schema (eg via psql \dt) for the table being
copied?

            regards, tom lane