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 96A4152A68 for ; Thu, 24 Feb 2005 18:31:54 +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 71256-07 for ; Thu, 24 Feb 2005 18:31:53 +0000 (GMT) Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by svr1.postgresql.org (Postfix) with ESMTP id 70B3052A52 for ; Thu, 24 Feb 2005 18:31:52 +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 j1OIVZvD021843; Thu, 24 Feb 2005 13:31:35 -0500 Message-ID: <421E1D8A.8050203@turbocorp.com> Date: Thu, 24 Feb 2005 13:31:38 -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, john@arbash-meinel.com 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/351 X-Sequence-Number: 10680 Hello Again In the below statement you mention putting each database on its own raid mirror. "However, sticking with your arrangement, it would seem that you might be able to get some extra performance if each database is on it's own raid, since you are fairly likely to have 2 transactions occuring at the same time, that don't affect eachother (since you wouldn't have any foreign keys, etc on 2 separate databases.)" That would take alot of disk drives to accomplish. I was thinking maybe putting three or four databases on each raid and dividing the heaviest used databases on each mirrored set. And for each of these sets have its own mirror for pg_xlog. My question is what is the best way to setup postgres databases on different disks. I have setup multiple postmasters on this system as a test. The only problem was configuring each databases "ie postgresql.conf, pg_hba.conf". Is there anyway in postgres to have everything in one cluster and have it seperated onto multiple drives. Here is a example of what is was thinking about. MIRROR1 - Database Group 1 MIRROR2 - pg_xlog for database group 1 MIRROR3 - Database Group 2 MIRROR4 - pg_xlog for database group 2 MIRROR5 - Database Group 3 MIRROR6 - pg_xlog for database group 3 This will take about 12 disk drives. I have a 14 bay Storage Bay I can use two of the drives for hotspare's. Thanks John Allgood - ESC Systems Administrator