Tom Duffey <tduffey@xxxxxxxxxxxxxx> writes: > I have a table with several hundred million rows of timestamped > values. Using pg_dump we are able to dump the entire table to disk no > problem. However, I would like to retrieve a large subset of data > from this table using something like: > COPY (SELECT * FROM history WHERE timestamp > '2009-01-01') TO STDOUT; > Executing this query causes our server to consume all available swap > and crash. What's being done on the client side with the data? AFAIK that operation really shouldn't consume a lot of memory on the server side. It would help if you'd be more specific about which process is consuming swap space. 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
