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 1F4AD5352E for ; Fri, 1 Apr 2005 03:01:13 +0100 (BST) 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 70051-09 for ; Fri, 1 Apr 2005 02:01:11 +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 18022534E3 for ; Fri, 1 Apr 2005 03:01:10 +0100 (BST) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Thu, 31 Mar 2005 18:04:10 -0800 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Thu, 31 Mar 2005 18:04:06 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005033118040629150 for ; Thu, 31 Mar 2005 18:04:06 -0800 X-ASG-Debug-ID: 1112320869-14512-6-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 6E7372005D94 for ; Thu, 31 Mar 2005 18:01:09 -0800 (PST) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Thu, 31 Mar 2005 18:04:01 -0800 Message-ID: <424CAB5D.9020807@sfnet.cc> Date: Fri, 01 Apr 2005 02:01:01 +0000 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-performance@postgresql.org X-ASG-Orig-Subj: Follow-Up: How to improve db performance with $7K? Subject: Follow-Up: 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> <42455DEC.2080301@sfnet.cc> <1112049794.23284.29.camel@localhost.localdomain> <424840AE.3050200@sfnet.cc> <1112107974.7903.28.camel@sixtyfour.internetstaff.com> In-Reply-To: <1112107974.7903.28.camel@sixtyfour.internetstaff.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 01 Apr 2005 02:04:01.0778 (UTC) FILETIME=[12F53520:01C5365F] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: -0.90 X-Barracuda-Spam-Status: No, SCORE=-0.90 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_30 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.2403 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -0.90 BAYES_30 BODY: Bayesian spam probability is 30 to 40% [score: 0.3961] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.219 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/1 X-Sequence-Number: 11398 Thanks for everyone's feedback on to best improve our Postgresql database for the animal hospital. I re-read the PostgreSQL 8.0 Performance Checklist just to keep focused. We purchased (2) 4 x 146GB 10,000rpm SCSI U320 SCA drive arrays ($2600) and (1) Sun W2100z dual AMD64 workstation with 4GB RAM ($2500). We did not need a rack-mount server, so I though Sun's workstation would do fine. I'll double the RAM. Hopefully, this should out-perform our dual 2.8 Xeon with 4GB of RAM. Now, we need to purchase a good U320 RAID card now. Any suggestions for those which run well under Linux? These two drive arrays main purpose is for our database. For those messed with drive arrays before, how would you slice-up the drive array? Will database performance be effected how our RAID10 is configured? Any suggestions? Thanks. Steve Poe