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 2923B534C8 for ; Sat, 26 Mar 2005 21:31:19 +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 47693-01 for ; Sat, 26 Mar 2005 21:31:18 +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 D73D75343E for ; Sat, 26 Mar 2005 21:31:17 +0000 (GMT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Sat, 26 Mar 2005 13:34:14 -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:34:12 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005032613341215857 for ; Sat, 26 Mar 2005 13:34:12 -0800 X-ASG-Debug-ID: 1111872677-1796-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 2A79720048E1 for ; Sat, 26 Mar 2005 13:31:17 -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:34:08 -0800 Message-ID: <42456158.3090404@sfnet.cc> Date: Sat, 26 Mar 2005 13:19:20 +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: 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:34:08.0263 (UTC) FILETIME=[8ACE2970:01C5324B] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: -0.58 X-Barracuda-Spam-Status: No, SCORE=-0.58 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_20, DATE_IN_PAST_06_12 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.2159 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -1.43 BAYES_20 BODY: Bayesian spam probability is 20 to 30% [score: 0.2298] 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.867 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/587 X-Sequence-Number: 11292 >The Chenbros are nice, but kinda pricey ($800) if Steve doesn't need the >machine to be rackable. > >If your primary goal is redundancy, you may wish to consider the possibility >of building a brand-new machine for $7k (you can do a lot of machine for >$7000 if it doesn't have to be rackable) and re-configuring the old machine >and using it as a replication or PITR backup. This would allow you to >configure the new machine with only a moderate amount of hardware redundancy >while still having 100% confidence in staying running. > > > Our servers are not racked, so a new one does not have to be. *If* it is possible, I'd like to replace the main server with a new one. I could tweak the new one the way I need it and work with the vendor to make sure everything works well. In either case, I'll still need to test how positioning of the tables/indexes across a raid10 will perform. I am also waiting onProIV developers feedback. If their ProvIV modules will not run under AMD64, or take advantage of the processor, then I'll stick with the server we have. Steve Poe