X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E2829D1B23F; Wed, 26 May 2004 14:21:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67054-06; Wed, 26 May 2004 14:20:56 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id F34ECD1B175; Wed, 26 May 2004 14:20:54 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i4QHKrT1041750; Wed, 26 May 2004 17:20:54 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i4QHA4Kd023235; Wed, 26 May 2004 17:10:04 GMT From: Chris Browne X-Newsgroups: comp.databases.postgresql.performance, comp.databases.postgresql.patches Subject: Re: tuning for AIX 5L with large memory Date: Wed, 26 May 2004 12:37:24 -0400 Organization: cbbrowne Computing Inc Lines: 53 Message-ID: <60brkbdu0r.fsf@dev6.int.libertyrms.info> References: <40AE8F78.2070901@drivefaster.net> <40AEBB73.7010105@samurai.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110003 (No Gnus v0.3) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:eaOcZu0G9kvc0F4ipBPXo08lXmo= To: "pgsql-patches@postgresql.org.pgsql-performance"@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/386 X-Sequence-Number: 11102 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... 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 @@ + + AIX + AIXIPC configuration + + + At least as of version 5.1, it should not be necessary to do + any special configuration for such parameters as + SHMMAX, 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 DB/2. + + It may, however, be necessary to modify the global + ulimit information in + /etc/security/limits, as the default hard + limits for filesizes (fsize) and numbers of + files (nofiles) may be too low. + + + Solaris -- 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!!