Re: AIX - Out of Memory

"Thorne, Francis" <thornef(at)cromwell(dot)co(dot)uk> writes:
> Looking for some help with regards to an 'Out of Memory' issue I have
> with our Postgresql install on AIX. When running large updates or
> select queries we get an out of memory error returned and details
> entered in the log file like below. This is a 64-bit install and I have
> set the ulimit for the postgres user to unlimited.

The bloat seems to be here:

> AfterTriggerEvents: 131063808 total in 26 blocks; 576 free (7
> chunks); 131063232 used

but it's hard to believe you'd be getting "out of memory" after only
130MB in a 64-bit build. Are you *sure* the postgres executable is
64-bit? Are you *sure* the postmaster has been launched with
nonrestrictive ulimit? On lots of setups that takes modifying the
PG startup script, not just fooling with some user's .profile.

> This is a 64-bit install (8.3) on AIX 5.3

8.3.what?

regards, tom lane