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 6F4BDDB849 for ; Wed, 16 Nov 2005 09:57:26 -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 10778-06 for ; Wed, 16 Nov 2005 13:57:27 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 7F518DB889 for ; Wed, 16 Nov 2005 09:57:22 -0400 (AST) Received: from nmd.esds.den.wayport.net (nmd.esds.den.wayport.net [64.134.13.30]) by svr2.postgresql.org (Postfix) with ESMTP id 4DFF0F0BBF for ; Wed, 16 Nov 2005 13:57:25 +0000 (GMT) Received: from nmd.esds.den.wayport.net (localhost [[UNIX: localhost]]) by nmd.esds.den.wayport.net (8.12.10/8.12.10) with ESMTP id jAGDvCNZ024054; Wed, 16 Nov 2005 06:57:13 -0700 Message-ID: <437B3B18.1040509@commandprompt.com> Date: Wed, 16 Nov 2005 05:58:48 -0800 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5 (Windows/20051025) MIME-Version: 1.0 To: Alex Turner Cc: Luke Lonergan , Adam Weisberg , pgsql-performance@postgresql.org Subject: Re: Hardware/OS recommendations for large databases ( References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> <33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com> In-Reply-To: <33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/271 X-Sequence-Number: 15528 >> 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. >> >> > > Spend a fortune on dual core CPUs and then buy crappy disks... I bet > for most applications this system will be IO bound, and you will see a > nice lot of drive failures in the first year of operation with > consumer grade drives. > There is nothing wrong with using SATA disks and they perform very well. The catch is, make sure you have a battery back up on the raid controller. > Spend your money on better Disks, and don't bother with Dual Core IMHO > unless you can prove the need for it. > The reason you want the dual core cpus is that PostgreSQL can only execute 1 query per cpu at a time, so the application will see a big boost in overall transactional velocity if you push two dual-core cpus into the machine. Joshua D. Drake > Alex > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >