X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6C935D1B16A for ; Fri, 21 May 2004 20:23:55 -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 80192-06 for ; Fri, 21 May 2004 20:23:36 -0300 (ADT) Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by svr1.postgresql.org (Postfix) with ESMTP id C9FD3D1B25F for ; Fri, 21 May 2004 20:23:33 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id B9274BF87 for ; Fri, 21 May 2004 17:22:08 -0600 (MDT) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25861-06 for ; Fri, 21 May 2004 17:22:08 -0600 (MDT) Received: from [192.168.1.12] (c-24-9-24-35.client.comcast.net [24.9.24.35]) by crestone.coronasolutions.com (Postfix) with ESMTP id 6206FBDD9 for ; Fri, 21 May 2004 17:22:08 -0600 (MDT) Message-ID: <40AE8F78.2070901@drivefaster.net> Date: Fri, 21 May 2004 17:23:36 -0600 From: Dan Harris User-Agent: Mozilla Thunderbird 0.6 (Macintosh/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: tuning for AIX 5L with large memory Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at drivefaster.net X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/192 X-Sequence-Number: 7023 I will soon have at my disposal a new IBM pSeries server. The main mission for this box will be to serve several pg databases. I have ordered 8GB of RAM and want to learn the best way to tune pg and AIX for this configuration. Specifically, I am curious about shared memory limitations. I've had to tune the shmmax on linux machines before but I'm new to AIX and not sure if this is even required on that platform? Google has not been much help for specifics here. Hoping someone else here has a similar platform and can offer some advice.. Thanks! -Dan Harris