Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] out of memory

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] out of memory
Date: 2012-11-05 17:30:30
Message-ID: 5097F7B6.4040300@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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

pgsql-performance by date

Next:From: Claudio FreireDate: 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 HaasDate: 2012-11-05 17:27:17
Subject: Re: [HACKERS] out of memory

pgsql-hackers by date

Next:From: Robert HaasDate: 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 HaasDate: 2012-11-05 17:27:17
Subject: Re: [HACKERS] out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group