pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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!!

view thread (6+ messages)  latest in thread

Message-ID: <60brkbdu0r.fsf@dev6.int.libertyrms.info>
Permalink:  ../60brkbdu0r.fsf@dev6.int.libertyrms.info/
Also on:    postgresql.org/message-id/60brkbdu0r.fsf@dev6.int.libertyrms.info

 ·  · 

reply

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