Tom Duffey <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
