On 11/05/12 9:27 AM, Robert Haas wrote:
> That is, if we have a large datum that we're trying to
> send back to the client, could we perhaps chop off the first 50MB or
> so, do the encoding on that amount of data, send the data to the
> client, lather, rinse, repeat?

I'd suggest work_mem sized chunks for this?



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

In response to

• Re: [HACKERS] out of memory at 2012-11-05 17:27:17 from Robert Haas

pgsql-performance by date

Next:	From: Claudio Freire	Date: 2012-11-05 17:40:31
	Subject: Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Previous:	From: Robert Haas	Date: 2012-11-05 17:27:17
	Subject: Re: [HACKERS] out of memory

pgsql-hackers by date

Next:	From: Robert Haas	Date: 2012-11-05 17:33:05
	Subject: Re: What are the advantages of not being able to access multiple databases with one connection?
Previous:	From: Robert Haas	Date: 2012-11-05 17:27:17
	Subject: Re: [HACKERS] out of memory