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 3BE2A5392D for ; Sat, 26 Mar 2005 21:16:47 +0000 (GMT) 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 42086-09 for ; Sat, 26 Mar 2005 21:16:43 +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 35592539B0 for ; Sat, 26 Mar 2005 21:16:42 +0000 (GMT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Sat, 26 Mar 2005 13:19:39 -0800 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Sat, 26 Mar 2005 13:19:37 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005032613193715845 for ; Sat, 26 Mar 2005 13:19:37 -0800 X-ASG-Debug-ID: 1111871802-32331-0-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail2 (mail2.hq.corp [192.168.160.6]) by barracuda.tecarta.com (Spam Firewall) with SMTP id 392CF20048E2 for ; Sat, 26 Mar 2005 13:16:42 -0800 (PST) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Sat, 26 Mar 2005 13:19:32 -0800 Message-ID: <42455DEC.2080301@sfnet.cc> Date: Sat, 26 Mar 2005 13:04:44 +0000 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Josh Berkus Cc: Bjoern Metzdorf , performance pgsql X-ASG-Orig-Subj: Re: [PERFORM] How to improve db performance with $7K? Subject: Re: How to improve db performance with $7K? References: <42443863.4040302@sfnet.cc> <4244A90B.2030200@sfnet.cc> <42453273.2060509@turtle-entertainment.de> <200503261255.59007.josh@agliodbs.com> In-Reply-To: <200503261255.59007.josh@agliodbs.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 26 Mar 2005 21:19:32.0713 (UTC) FILETIME=[80EFD590:01C53249] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: 0.84 X-Barracuda-Spam-Status: No, SCORE=0.84 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_44, DATE_IN_PAST_06_12 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.2158 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -0.00 BAYES_44 BODY: Bayesian spam probability is 44 to 50% [score: 0.4985] 0.85 DATE_IN_PAST_06_12 Date: is 6 to 12 hours before Received: date X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.844 tagged_above=0 required=5 tests=AWL, DATE_IN_PAST_06_12, FORGED_RCVD_HELO, NO_DNS_FOR_FROM X-Spam-Level: X-Archive-Number: 200503/586 X-Sequence-Number: 11291 >Steve, can we clarify that you are not currently having any performance >issues, you're just worried about failure? Recommendations should be based >on whether improving applicaiton speed is a requirement ... Josh, The priorities are: 1)improve safety/failure-prevention, 2) improve performance. The owner of the company wants greater performance (and, I concure to certain degree), but the owner's vote is only 1/7 of the managment team. And, the rest of the management team is not as focused on performance. They all agree in safety/failure-prevention. Steve