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 1992CD1B4C3 for ; Mon, 15 Dec 2003 05:30:15 +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 89743-09 for ; Mon, 15 Dec 2003 01:29:47 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 48F42D1B475 for ; Mon, 15 Dec 2003 01:29:46 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hBF5TjU6033273 for ; Mon, 15 Dec 2003 05:29:45 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hBF5Kcla022421 for pgsql-performance@postgresql.org; Mon, 15 Dec 2003 05:20:38 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Hardware suggestions for Linux/PGSQL server Date: Mon, 15 Dec 2003 00:14:29 -0500 Organization: cbbrowne Computing Inc Lines: 23 Message-ID: References: <3FDD35CF.6080103@xyzzy.dhs.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:H/KAfwMrnYKY8ZSp0EHFd9u1trI= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/224 X-Sequence-Number: 5084 In the last exciting episode, drew@xyzzy.dhs.org ("Andrew G. Hammond") wrote: > 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. We got a couple of those in for testing purposes; when opportunity presents itself, I'll have to check to see if they are any more honest about commits than traditional IDE drives. If they still "lie" the same way IDE drives do, it is entirely possible that they are NOT nearly as impressive as you presently imagine. It's not much good if they're "way fast" if you can't trust them to actually store data when they claim it is stored... -- (reverse (concatenate 'string "gro.gultn" "@" "enworbbc")) http://www.ntlug.org/~cbbrowne/lisp.html "Much of this software was user-friendly, meaning that it was intended for users who did not know anything about computers, and furthermore had absolutely no intention whatsoever of learning." -- A. S. Tanenbaum, "Modern Operating Systems, ch 1.2.4"