Tom Duffey <tduffey@xxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
