X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 846DB538BC for ; Fri, 15 Apr 2005 15:12:20 -0300 (ADT) 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 08816-03 for ; Fri, 15 Apr 2005 18:12:19 +0000 (GMT) Received: from mail.tecarta.com (66.238.115.135.ptr.us.xo.net [66.238.115.135]) by svr1.postgresql.org (Postfix) with ESMTP id 1A4DA53853 for ; Fri, 15 Apr 2005 15:12:18 -0300 (ADT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Fri, 15 Apr 2005 11:15:18 -0700 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Fri, 15 Apr 2005 11:15:16 -0700 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005041511151604449 for ; Fri, 15 Apr 2005 11:15:16 -0700 X-ASG-Debug-ID: 1113588734-32253-7-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail1 (mail1.hq.corp [192.168.160.5]) by barracuda.tecarta.com (Spam Firewall) with SMTP id 4B1EA200D0F6 for ; Fri, 15 Apr 2005 11:12:14 -0700 (PDT) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Fri, 15 Apr 2005 11:15:11 -0700 Message-ID: <426003DC.2020008@sfnet.cc> Date: Fri, 15 Apr 2005 11:11:40 -0700 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Mohan, Ross" Cc: pgsql-performance@postgresql.org X-ASG-Orig-Subj: Re: [PERFORM] Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How to Improve w/7K$? Subject: Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 15 Apr 2005 18:15:11.0809 (UTC) FILETIME=[1062D310:01C541E7] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_50 X-Barracuda-Spam-Report: Code version 3.02, rules version 3.0.313 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.00 BAYES_50 BODY: Bayesian spam probability is 40 to 60% [score: 0.5006] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.181 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/359 X-Sequence-Number: 11756 Ross, I agree with you, but I' am the lowly intergrator/analyst, I have to solve the problem without all the authority (sounds like a project manager). I originally started this thread since I had the $7k budget. I am not a dba/developer. but I play one on t.v., so I can only assume that throwing money at the application code means one understand what the bottleneck in the code and what it takes to fix it. In this situation, the code is hidden by the vendor that connects to the database. So, besides persisent requests of the vendor to improve the area of the application, the balance of tuning lies with the hardware. The answer is *both* hardware and application code. Finding the right balance is key. Your mileage may vary. Steve Poe >If, however, in the far-more-likely case that the application code >or system/business process is the throttle point, it'd be a great >use of money to have a test report showing that to the "higher ups". >That's where the best scalability bang-for-buck can be made. - Ross >p.s. having said this, and as already been noted "7K" ain't > going to buy that much....maybe the ability to go RAID 10? >p.p.s Why don't we start a PGSQL-7K listserv, to handle this EPIC thread? :-)