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 3DE1052A69 for ; Thu, 24 Feb 2005 19:08:30 +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 18854-07 for ; Thu, 24 Feb 2005 19:08:21 +0000 (GMT) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by svr1.postgresql.org (Postfix) with ESMTP id 57DE352A68 for ; Thu, 24 Feb 2005 19:08:20 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0ICF00IWZJU7JGW0@vms044.mailsrvcs.net> for pgsql-performance@postgresql.org; Thu, 24 Feb 2005 13:08:32 -0600 (CST) Date: Thu, 24 Feb 2005 14:12:29 -0500 From: "Joel Fradkin" Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout In-reply-to: <421E1D8A.8050203@turbocorp.com> To: "'John Allgood'" , , Message-id: <005d01c51aa4$c9dd00f0$797ba8c0@jfradkin> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.151 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/352 X-Sequence-Number: 10681 I am no expert, but have been asking them a bunch and I think your = missing a key concept. The data is best on several drives. I could be completely off, but if I understood (I just finished doing = the same kind of thing minus several databases) you want your WAL on fast = drives in raid 1 and your data (as many drives as you can use) on raid 10 (can = be slower drives , but I saw you already have a bunch of 15k drives). So you may get best performance just using one database rather then = several smaller ones on mirrored data drives. Keep in mind if you go with ES4 (I = am using AS4) and postgres 8 you can add spindles and move hard hit tables = to their own spindle. Again I am no expert; just thought I would echo what I was informed. I ended up using 2 15k drives in raid 1 for my WAL and 4 10k drives for = my data in raid 10. I ended up using links to these from the original = install of postgres on the raid 5, 4 15k drives inside the server itself. I = believe this gives me three separate raid arrays for my install with logs and = such on the raid 5, data on the raid 10 and wal on the raid 1. I am in the testing and conversion phase and have found it very fast. I used a 4 processor Dell 6550, but think from what I have been told your computer would have been a better choice (CPU wise). I am not using fibre but do = have a 14 drive powervault which I split to have the 15k's on one side and = the 10k's on the other. So I am using both channels of the controller. I = have been told for me to get best performance I should add as many 10k drives = to my data array as I can (but this was all I had in my budget). I have = room for 3 more drives on that side of the powervault. Best of luck on your project. Joel