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 0E63DD1E3F8 for ; Sun, 23 May 2004 03:55: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 06463-02 for ; Sun, 23 May 2004 03:55:32 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 7A28FD1EBD5 for ; Sun, 23 May 2004 03:05:14 -0300 (ADT) Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by www.postgresql.com (Postfix) with ESMTP id 95148CF8AE0 for ; Sun, 23 May 2004 00:30:20 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id 0FAECBFC2 for ; Sat, 22 May 2004 21:28:46 -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 00729-10 for ; Sat, 22 May 2004 21:28:45 -0600 (MDT) Received: from drivefaster.net (c-24-9-24-35.client.comcast.net [24.9.24.35]) by crestone.coronasolutions.com (Postfix) with ESMTP id 7CC4DBDD0 for ; Sat, 22 May 2004 21:28:45 -0600 (MDT) Message-ID: <40B01AD1.1050708@drivefaster.net> Date: Sat, 22 May 2004 21:30:25 -0600 From: Dan Harris User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-performance@postgresql.org Subject: Re: tuning for AIX 5L with large memory References: <40AE8F78.2070901@drivefaster.net> In-Reply-To: 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/196 X-Sequence-Number: 7027 Christopher Browne wrote: >We have a couple of these at work; they're nice and fast, although the >process of compiling things, well, "makes me feel a little unclean." > > > > Thanks very much for your detailed reply, Christopher. Would you mind elaborating on the "makes me feel a little unclean" statement? Also, I'm curious which models you are running and if you have any anecdotal comparisons for perfomance? I'm completely unfamiliar with AIX, so if there are dark corners that await me, I'd love to hear a little more so I can be prepared. I'm going out on a limb here and jumping to an unfamiliar architecture as well as OS, but the IO performance of these systems has convinced me that it's what I need to break out of my I/O limited x86 systems. I suppose when I do get it, I'll just experiment with different sizes of shared memory and run some benchmarks. For the price of these things, they better be some good marks! Thanks again -Dan Harris