X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B6AC8D1B8A5 for ; Thu, 28 Aug 2003 02:22:46 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 13878-01 for ; Wed, 27 Aug 2003 23:22:18 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 74F78D1B95B for ; Wed, 27 Aug 2003 23:22:10 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h7S2MAek055357 for ; Thu, 28 Aug 2003 02:22:10 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h7S27Wjb052828 for pgsql-performance@postgresql.org; Thu, 28 Aug 2003 02:07:32 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Hardware recommendations to scale to silly load Date: Wed, 27 Aug 2003 22:07:20 -0400 Organization: cbbrowne Computing Inc Lines: 22 Message-ID: References: <1061948112.15800.53.camel@gibraltar.mattclark.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) Cancel-Lock: sha1:Avfjn3vaxcf7lUjjnf8QraKP8jQ= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/374 X-Sequence-Number: 3190 After takin a swig o' Arrakan spice grog, scott.marlowe@ihs.com ("scott.marlowe") belched out... :-): > whether you like it or not, you're gonna need heavy iron if you need > to do this all in one hour once a week. The other thing worth considering is trying to see if there is a way of partitioning the workload across multiple hosts. At the point that you start going past hardware that is "over-the-counter commodity" stuff, the premiums start getting pretty high. Dual-CPU Intel boxes are pretty cheap compared to buncha-CPU Sparc boxes. If some sort of segmentation of the workload can be done, whether by area code, postal code, or perhaps the last couple digits of the caller's phone number, or even a "round robin," it's likely to be a lot cheaper to get an array of 4 Dual-Xeon boxes with 8 disk drives apiece than a Sun/HP/IBM box with 16 CPUs. -- let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;; http://cbbrowne.com/info/linuxxian.html "Show me... show me... show me... COMPUTERS!"