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 5E995DB807 for ; Tue, 15 Nov 2005 10:18: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 36252-04 for ; Tue, 15 Nov 2005 14:18:26 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 74324DB7EB for ; Tue, 15 Nov 2005 10:18:20 -0400 (AST) Received: (qmail 12139 invoked from network); 15 Nov 2005 14:18:24 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 15 Nov 2005 14:18:24 -0000 In-Reply-To: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: multipart/alternative; boundary=Apple-Mail-26--861917900 Message-Id: Cc: "Adam Weisberg" , pgsql-performance@postgresql.org From: Dave Cramer Subject: Re: Hardware/OS recommendations for large databases ( Date: Tue, 15 Nov 2005 09:15:04 -0500 To: Luke Lonergan X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/244 X-Sequence-Number: 15501 --Apple-Mail-26--861917900 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed 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, --Apple-Mail-26--861917900 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1 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.=A0 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. =A0

=


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,

=

= --Apple-Mail-26--861917900--