Re: AIX - Out of Memory

On Thu, 2010-02-18 at 08:46 +0000, Thorne, Francis wrote:
> Hi Brad,
>
> Thanks for all your help with this, sorry for my ignorance on this.
> I've read through the F.A.O and found the section on setting MAXDATA but
> can only see the example of setting this to 0x00000000 for 32-bit. I
> cant see any example of what I need to change this to if I wanted to run
> 64-bit, I don't suppose you have an idea what I would need to change
> this maxData figure to.

We've set ours to the upper limit of 2GB (0x80000000). Your usage may
vary. You'll need to take into account the expected size of your
processes * the number of expected processes and make sure you have
enough RAM in the system to handle it.

> I assume using the LDEDIT command the maxData setting can be changed on
> the fly and we wont need to re-compile Postgres.

It can be, but I'm not sure exactly which components you will need to
touch.

We always build our binaries passing with this set higher, so I can't
comment on the effects of changing it on existing ones.

> Thanks again for all your help and patience !!
>
> Fran
>
> -----Original Message-----
> From: Brad Nicholson [mailto:bnichols(at)ca(dot)afilias(dot)info]
> Sent: 16 February 2010 18:46
> To: Thorne, Francis
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: RE: [ADMIN] AIX - Out of Memory
>
> On Tue, 2010-02-16 at 16:44 +0000, Thorne, Francis wrote:
> > Please find details as requested, thanks again for you help
> >
> > /usr/local/pgsql837-64/bin/postgres:
> >
> > ***Object Module Header***
> > # Sections Symbol Ptr # Symbols Opt Hdr Len Flags
> > 4 0x005e247c 46124 120 0x9002
> > Flags=( EXEC DYNLOAD RWNONEXEC )
> > Timestamp = "06 Nov 12:55:11 2009"
> > Magic = 0x1f7 (64-bit XCOFF)
>
> Your binary is 64-bit.
>
> > ***Optional Header***
> > Tsize Dsize Bsize Tstart Dstart
> > 0x003cc912 0x0005dde6 0x00073a38 0x100001f8 0x20000b0a
> >
> > SNloader SNentry SNtext SNtoc SNdata
> > 0x0004 0x0002 0x0001 0x0002 0x0002
> >
> > TXTalign DATAalign TOC vstamp entry
> > 0x0005 0x0003 0x20059418 0x0001 0x20039c6c
> >
> > maxSTACK maxDATA SNbss magic modtype
> > 0x00000000 0x00000000 0x0003 0x010b 1L
>
> Bingo - maxDATA of 0x00000000. Ken's posting was correct. You have
> 1x256MB segment of memory available per process.
>
> If you watch your server process while this is happening, it will be
> hitting 256MB in size.
>
> Upping this limit is probably the way to go. You can use the ldedit
> command to up this limit for your binaries, or specify it when you build
> Postgres. See the file docs/FAQ_AIX with the PG source for details.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.