Re: out of memory during query execution - Mailing list pgsql-general

From Seneca Cunningham
Subject Re: out of memory during query execution
Date
Msg-id 43A97933.1090307@ca.afilias.info
Whole thread Raw
In response to Re: out of memory during query execution  (DANTE ALEXANDRA <ALEXANDRA.DANTE@BULL.NET>)
List pgsql-general
DANTE ALEXANDRA wrote:
> Last question, how can I see that my 32-bit AIX program being limited to
> 256MB of heap, as the user "pg_810" used to launch the postmaster got
> when I execute the "ulimit -a" command :
> $ ulimit -a
> time(seconds)        unlimited
> file(blocks)         unlimited
> data(kbytes)         unlimited
> stack(kbytes)        unlimited
> memory(kbytes)       unlimited
> coredump(blocks)     unlimited
> nofiles(descriptors) 2000

It's actually less than 256MB of heap.  When I saw your ./configure, I
noticed that no special options were passed to the linker, so you're
using the default 32-bit memory model.  Even an unlimited ulimit does
not allow for more memory than the model sets aside.

You can try setting the environment variable LDR_CNTRL to
MAXDATA=0x40000000 (where the first digit is the number of 256MB
segments to allocate to heap, max 8) before starting the postmaster, at
the cost of reducing the amount of shared memory addressable by postgres.

Diagram of default memory model (Figure 3-3):
  <http://www.redbooks.ibm.com/redbooks/SG245674/images/11-08-05.jpg>

The redbook it's from, "Developing and Porting C and C++ Applications on
AIX":
  <http://www.redbooks.ibm.com/redbooks/SG245674/>

--
Seneca Cunningham
scunning@ca.afilias.info

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: out of memory during query execution
Next
From: Jerry LeVan
Date:
Subject: Funky template1 problem?