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 98ED7DB945 for ; Wed, 16 Nov 2005 13:09:41 -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 36233-04 for ; Wed, 16 Nov 2005 17:09:40 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id EFF5ADB93D for ; Wed, 16 Nov 2005 13:09:38 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 16 Nov 2005 11:09:38 -0600 Subject: Re: Hardware/OS recommendations for large databases ( From: Scott Marlowe To: William Yu Cc: pgsql-performance@postgresql.org In-Reply-To: References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> <33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1132160978.3582.64.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 16 Nov 2005 11:09:38 -0600 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/285 X-Sequence-Number: 15542 On Wed, 2005-11-16 at 09:33, William Yu wrote: > Alex Turner wrote: > > 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. > > > > Spend your money on better Disks, and don't bother with Dual Core IMHO > > unless you can prove the need for it. > > I would say the opposite -- you always want Dual Core nowadays. DC > Opterons simply give you better bang for the buck than single core > Opterons. Price out a 1xDC system against a 2x1P system -- the 1xDC will > be cheaper. Do the same for 2xDC versus 4x1P, 4xDC versus 8x1P, 8xDC > versus 16x1P, etc. -- DC gets cheaper by wider and wider margins because > those mega-CPU motherboards are astronomically expensive. The biggest gain is going from 1 to 2 CPUs (real cpus, like the DC Opterons or genuine dual CPU mobo, not "hyperthreaded"). Part of the issue isn't just raw CPU processing power. The second CPU allows the machine to be more responsive because it doesn't have to context switch as much. While I've seen plenty of single CPU servers start to bog under load running one big query, the dual CPU machines always seem more than just twice as snappy under similar loads.