"Thorne, Francis" <thornef@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
