Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] out of memory - Mailing list pgsql-hackers

From John R Pierce
Subject Re: [PERFORM] out of memory
Date
Msg-id 5097F7B6.4040300@hogranch.com
Whole thread Raw
In response to Re: [PERFORM] out of memory  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PERFORM] out of memory
Next
From: Robert Haas
Date:
Subject: Re: What are the advantages of not being able to access multiple databases with one connection?