X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 082C0DBB93 for ; Wed, 16 Nov 2005 11:46:24 -0400 (AST) 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 24941-08 for ; Wed, 16 Nov 2005 15:46:27 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id D6B39DBB86 for ; Wed, 16 Nov 2005 11:46:20 -0400 (AST) Received: from [10.30.1.41] ([72.16.194.3]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id jAGFfGtd032572; Wed, 16 Nov 2005 07:41:22 -0800 Message-ID: <437B54A9.5070104@commandprompt.com> Date: Wed, 16 Nov 2005 07:47:53 -0800 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5 (Windows/20051025) MIME-Version: 1.0 To: David Boreham CC: pgsql-performance@postgresql.org Subject: Re: Hardware/OS recommendations for large databases ( References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> <33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com> <437B3B18.1040509@commandprompt.com> <437B4773.1040404@boreham.org> In-Reply-To: <437B4773.1040404@boreham.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Wed, 16 Nov 2005 07:41:23 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/281 X-Sequence-Number: 15538 > > I guess I've never bought into the vendor story that there are > two reliability grades. Why would they bother making two > different kinds of bearing, motor etc ? Seems like it's more > likely an excuse to justify higher prices. In my experience the > expensive SCSI drives I own break frequently while the cheapo > desktop drives just keep chunking along (modulo certain products > that have a specific known reliability problem). I don't know if the reliability grade is true or not but what I can tell you is that I have scsi drives that are 5+ years old that still work without issue. I have never had an IDE drive last longer than 3 years (when used in production). That being said, so what. That is what raid is for. You loose a drive and hot swap it back in. Heck keep a hotspare in the trays. Joshua D. Drake > > I'd expect that a larger number of hotter drives will give a less > reliable > system than a smaller number of cooler ones. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org