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@xxxxxxxxxxxxxxx