From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thorne, Francis <thornef@cromwell.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: AIX - Out of Memory
Date: Mon, 15 Feb 2010 10:57:06 -0500
Message-ID: <29675.1266249426@sss.pgh.pa.us> (raw)
In-Reply-To: <81976671721DF04B9DCA6ECD87941A401E166CBE@roundway.Cromwell-tools.co.uk>
References: <81976671721DF04B9DCA6ECD87941A401E166CBE@roundway.Cromwell-tools.co.uk>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, thornef@cromwell.co.uk
Subject: Re: AIX - Out of Memory
In-Reply-To: <29675.1266249426@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox