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 9AFC8D98C9 for ; Wed, 16 Nov 2005 01:17:01 -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 81862-05 for ; Wed, 16 Nov 2005 05:17:00 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by svr1.postgresql.org (Postfix) with ESMTP id 088DDD6D8C for ; Wed, 16 Nov 2005 01:16:57 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so1371511wri for ; Tue, 15 Nov 2005 21:16:58 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XaYXW3ZUpTMVJdW+unj/oK01MIfa71QAf1+nMLWCCdnm2PBfLWXjhFf6tbfd5V596ox8UUnUvdvnMK8D5g7y96qc02p1y0utx2rKyLqjbirFD+VPxtScl3HBzEERRO74JeQWAOoZvmwFzKTG1wjAgR5B1d9fo4EzGmxr8o9rTFI= Received: by 10.54.114.5 with SMTP id m5mr3159000wrc; Tue, 15 Nov 2005 21:16:58 -0800 (PST) Received: by 10.54.82.5 with HTTP; Tue, 15 Nov 2005 21:16:58 -0800 (PST) Message-ID: <33c6269f0511152116s4483af82s91c711b1b902da14@mail.gmail.com> Date: Wed, 16 Nov 2005 00:16:58 -0500 From: Alex Turner To: Dave Cramer Subject: Re: Hardware/OS recommendations for large databases ( Cc: Luke Lonergan , Adam Weisberg , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/264 X-Sequence-Number: 15521 Not at random access in RAID 10 they aren't, and anyone with their head screwed on right is using RAID 10. The 9500S will still beat the Areca cards at RAID 10 database access patern. Alex. On 11/15/05, Dave Cramer wrote: > Luke, > > Have you tried the areca cards, they are slightly faster yet. > > Dave > > On 15-Nov-05, at 7:09 AM, Luke Lonergan wrote: > > > > > > I agree - you can get a very good one from www.acmemicro.com or > > www.rackable.com with 8x 400GB SATA disks and the new 3Ware 9550SX SATA > > RAID controller for about $6K with two Opteron 272 CPUs and 8GB of RAM > > on a Tyan 2882 motherboard. We get about 400MB/s sustained disk read > > performance on these (with tuning) on Linux using the xfs filesystem, > > which is one of the most critical factors for large databases. > > > > > Note that you want to have your DBMS use all of the CPU and disk channel > > bandwidth you have on each query, which takes a parallel database like > > Bizgres MPP to achieve. > > > > > Regards, >