From: Chris Browne <cbbrowne@acm.org>
To: " <pgsql-patches@postgresql.org.pgsql-performance>
Subject: Re: tuning for AIX 5L with large memory
Date: Wed, 26 May 2004 12:37:24 -0400
Message-ID: <60brkbdu0r.fsf@dev6.int.libertyrms.info> (raw)
References: <40AE8F78.2070901@drivefaster.net>
<m3vfip8d3r.fsf@wolfe.cbbrowne.com>
<40AEBB73.7010105@samurai.com>
neilc@samurai.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...
inline patch 1: runtime.sgml (+20/-0 lines) download inline-1.patchIndex: 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!!
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-performance@postgresql.org
Cc: cbbrowne@acm.org, pgsql-patches@postgresql.org.pgsql-performance
Subject: Re: tuning for AIX 5L with large memory
In-Reply-To: <60brkbdu0r.fsf@dev6.int.libertyrms.info>
* 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