X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 23FFAD1B475 for ; Mon, 15 Dec 2003 04:17:43 +0000 (GMT) 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 82579-09 for ; Mon, 15 Dec 2003 00:17:15 -0400 (AST) Received: from xyzzy.dhs.org (H98.C214.tor.velocet.net [216.138.214.98]) by svr1.postgresql.org (Postfix) with ESMTP id 53D77D1B44A for ; Mon, 15 Dec 2003 00:17:15 -0400 (AST) Received: from xyzzy.dhs.org (unknown [192.168.1.74]) by xyzzy.dhs.org (Postfix) with ESMTP id D27BD1B25E; Sun, 14 Dec 2003 23:17:13 -0500 (EST) Message-ID: <3FDD35CF.6080103@xyzzy.dhs.org> Date: Sun, 14 Dec 2003 23:17:19 -0500 From: "Andrew G. Hammond" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jeff Bohmer Cc: pgsql-performance@postgresql.org Subject: Re: Hardware suggestions for Linux/PGSQL server References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/223 X-Sequence-Number: 5083 I don't know what your budget is, but there are now 10k RPM SATA 150 drives on the market. Their price/performance is impressive. You may want to consider going with a bunch of these instead of SCSI disks (more spindles vs. faster spindles). 3ware makes a hardware raid card that can drive up to 12 SATA disks. I have been told by a few people who have used it that the linux driver is very solid. Drew Jeff Bohmer wrote: >> Just one more piece of advice, you might want to look into a good >> battery >> backed cache hardware RAID controller. They work quite well for heavily >> updated databases. The more drives you throw at the RAID array the >> faster >> it will be. > > > I've seen this list often recommended such a setup. We'll probably > get battery-backed write cache and start out with a 4 disk RAID 10 > array. Then add more disks and change RAID 5 if more read performance > is needed. > > Thanks, > - Jeff