Skip site navigation (1) Skip section navigation (2)

Re: tuning for AIX 5L with large memory

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: "pgsql-patches(at)postgresql(dot)org(dot)pgsql-performance"(at)postgresql(dot)org
Subject: Re: tuning for AIX 5L with large memory
Date: 2004-05-26 16:37:24
Message-ID: 60brkbdu0r.fsf@dev6.int.libertyrms.info (view raw or flat)
Thread:
Lists: pgsql-patchespgsql-performance
neilc(at)samurai(dot)com (Neil Conway) writes:
> Christopher Browne wrote:
>> One of our sysadmins did all the "configuring OS stuff" part; I don't
>> recall offhand if there was a need to twiddle something in order to
>> get it to have great gobs of shared memory.
>
> FWIW, the section on configuring kernel resources under various
> Unixen[1] doesn't have any documentation for AIX. If someone out there
> knows which knobs need to be tweaked, would they mind sending in a doc
> patch? (Or just specifying what needs to be done, and I'll add the
> SGML.)

After verifying that nobody wound up messing with the kernel
parameters, here's a docs patch...

Index: runtime.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/runtime.sgml,v
retrieving revision 1.263
diff -c -u -r1.263 runtime.sgml
--- runtime.sgml	29 Apr 2004 04:37:09 -0000	1.263
+++ runtime.sgml	26 May 2004 16:35:43 -0000
@@ -3557,6 +3557,26 @@
       </listitem>
      </varlistentry>
 
+     <varlistentry>
+      <term><systemitem class="osname">AIX</></term>
+      <indexterm><primary>AIX</><secondary>IPC configuration</></>
+      <listitem>
+       <para>
+        At least as of version 5.1, it should not be necessary to do
+        any special configuration for such parameters as
+        <varname>SHMMAX</varname>, as it appears this is configured to
+        allow all memory to be used as shared memory.  That is the
+        sort of configuration commonly used for other databases such
+        as <application>DB/2</application>.</para>
+
+       <para> It may, however, be necessary to modify the global
+       <command>ulimit</command> information in
+       <filename>/etc/security/limits</filename>, as the default hard
+       limits for filesizes (<varname>fsize</varname>) and numbers of
+       files (<varname>nofiles</varname>) may be too low.
+       </para>
+      </listitem>
+     </varlistentry>      
 
      <varlistentry>
       <term><systemitem class="osname">Solaris</></term>
-- 
select 'cbbrowne' || '@' || 'acm.org';
http://www.ntlug.org/~cbbrowne/linuxxian.html
Hail to the sun god, he sure is a fun god, Ra, Ra, Ra!! 

In response to

pgsql-performance by date

Next:From: Chris BrowneDate: 2004-05-26 16:58:55
Subject: Re: tuning for AIX 5L with large memory
Previous:From: Mario SotoDate: 2004-05-26 16:35:57
Subject: Re: [GENERAL] performance very slow

pgsql-patches by date

Next:From: Gaetano MendolaDate: 2004-05-26 16:44:12
Subject: Re: pg_ctl.c
Previous:From: Tom LaneDate: 2004-05-26 16:16:36
Subject: Re: Small patch for oracle_compat.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group