Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 9E0C16326E2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 15 Feb 2010 11:57:21 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 27074-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 15 Feb 2010 15:57:01 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id D4E3B63261E
	for <pgsql-admin@postgresql.org>; Mon, 15 Feb 2010 11:57:10 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o1FFv6AP029676;
	Mon, 15 Feb 2010 10:57:06 -0500 (EST)
To: "Thorne, Francis" <thornef@cromwell.co.uk>
cc: pgsql-admin@postgresql.org
Subject: Re: AIX - Out of Memory 
In-reply-to: 
 <81976671721DF04B9DCA6ECD87941A401E166CBE@roundway.Cromwell-tools.co.uk>
References: 
 <81976671721DF04B9DCA6ECD87941A401E166CBE@roundway.Cromwell-tools.co.uk>
Comments: In-reply-to "Thorne, Francis" <thornef@cromwell.co.uk>
	message dated "Mon, 15 Feb 2010 14:35:48 +0000"
Date: Mon, 15 Feb 2010 10:57:06 -0500
Message-ID: <29675.1266249426@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.466 tagged_above=-10 required=5 tests=AWL=0.133,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/121
X-Sequence-Number: 33724

"Thorne, Francis" <thornef@cromwell.co.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