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 28E1CD1DCF5 for ; Mon, 15 Dec 2003 16:38:21 +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 71518-07 for ; Mon, 15 Dec 2003 12:37:58 -0400 (AST) Received: from visionlink.org (mail.visionlink.org [208.139.207.159]) by svr1.postgresql.org (Postfix) with SMTP id 7E35BD1B461 for ; Mon, 15 Dec 2003 12:37:51 -0400 (AST) Received: from [65.100.170.142] (HELO [192.168.1.201]) by visionlink.org (Stalker SMTP Server 1.8b8) with ESMTP id S.0002324650 for ; Mon, 15 Dec 2003 09:39:01 -0700 Mime-Version: 1.0 X-Sender: bohmer@mail.visionlink.org Message-Id: In-Reply-To: References: <3FDD35CF.6080103@xyzzy.dhs.org> Date: Mon, 15 Dec 2003 09:37:29 -0700 To: pgsql-performance@postgresql.org From: Jeff Bohmer Subject: Re: Hardware suggestions for Linux/PGSQL server Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/225 X-Sequence-Number: 5085 >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... We lost data because of this very problem when a UPS didn't signal the shut down before it ran out of juice. Here's an excellent explanation of the problem: http://archives.postgresql.org/pgsql-general/2003-10/msg01343.php This post indicates that SATA drives still have problems, but a new ATA standard might fix things in the future: http://archives.postgresql.org/pgsql-general/2003-10/msg01395.php SATA RAID is a good option for a testing server, though. - Jeff -- Jeff Bohmer VisionLink, Inc. _________________________________ 303.402.0170 www.visionlink.org _________________________________ People. Tools. Change. Community.