X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 09D888B9EC7 for ; Wed, 23 Feb 2005 16:39:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57495-03 for ; Wed, 23 Feb 2005 16:39:23 +0000 (GMT) Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by svr1.postgresql.org (Postfix) with ESMTP id 074AE8B9E8E for ; Wed, 23 Feb 2005 16:39:22 +0000 (GMT) Received: from [198.212.166.61] (Voyager.turbocorp.com [198.212.166.61]) by Mercury.turbocorp.com (8.12.8/8.12.8) with ESMTP id j1NGdMvD001804 for ; Wed, 23 Feb 2005 11:39:22 -0500 Message-ID: <421CB1BF.2050708@turbocorp.com> Date: Wed, 23 Feb 2005 11:39:27 -0500 From: John Allgood User-Agent: Mozilla Thunderbird 1.0 (X11/20041207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Peformance Tuning Opterons/ Hard Disk Layout Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/325 X-Sequence-Number: 10654 Hello All I am setting up a hardware clustering solution. My hardware is Dual Opteron 550 with 8GB ram. My external storage is a Kingston Fibre channel Infostation. With 14 15000'k 36GB drives. The OS we are running is Redhat ES 3.0. Clustering using Redhat Cluster Suite. Postgres Version is Postgres 7.4.7. We will be setting up about 9 databases which range in size from 100MB to 2.5GB on the config. The postgres application is mostly read intensive. What would be the best way to setup the hardrives on this server. Currently I have it partioned with 2 seperate raid 5 with 1 failover per raid. I have two database clusters configured with a seperate postmaster running for each. Running two postmasters seems like a pain but that is the only way I knew to seperate the load. I am mostly concerned about disk IO and performance. Is my current setup a good way to accomplish the best performance or would it be better to use all the drives in one huge raid five with a couple of failovers. I have looked around in the archives and found some info but I would like to here about some of the configs other people are running and how they have them setup. Thanks John Allgood - ESC Systems Admin