Re: [PERFORM] Query memory usage greatly in excess of work_mem * query plan steps

2014-06-14 Thread Tom Lane
Timothy Garnett writes: > I have a query that's pulling data for another system using COPY (query) to > STDOUT CSV on a 9.2.4 db (we're in the process of upgrading to 9.3). > ... > We're running into problems with the machine running out of memory with > this single query process consuming over 10

Re: [PERFORM] Query memory usage greatly in excess of work_mem * query plan steps

2014-06-13 Thread Franklin, Dan
We had a problem in the 8.X series with COPY IN - it did not respect any configured maximums and just kept allocating memory until it could fit the entire COPY contents down to the \. into RAM. Could there be a similar issue with COPY OUT? - Dan On Wed, Jun 11, 2014 at 6:02 PM, Timothy Garn