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 38C9053358 for ; Sat, 26 Mar 2005 01:13: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 25961-09 for ; Sat, 26 Mar 2005 01:13:37 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 25511534CE for ; Sat, 26 Mar 2005 01:13:37 +0000 (GMT) Received: from [127.0.0.1] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2Q1Ackh029964; Fri, 25 Mar 2005 17:10:39 -0800 Message-ID: <4244B744.6020908@commandprompt.com> Date: Fri, 25 Mar 2005 17:13:40 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Steve Poe Cc: performance pgsql Subject: Re: How to improve db performance with $7K? References: <42443863.4040302@sfnet.cc> In-Reply-To: <42443863.4040302@sfnet.cc> Content-Type: multipart/mixed; boundary="------------090105010705070105060205" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/578 X-Sequence-Number: 11283 This is a multi-part message in MIME format. --------------090105010705070105060205 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Steve Poe wrote: > Situation: An 24/7 animal hospital (100 employees) runs their > business on Centos 3.3 (RHEL 3) Postgres 7.4.2 (because they have to) > off a 2-CPU Xeon 2.8MHz, 4GB of RAM, (3) SCSI disks RAID 0 (zcav value > 35MB per sec). The databse is 11GB comprised over 100 tables and > indexes from 1MB to 2GB in size. > > I recently told the hospital management team worst-case scenerio they > need to get the database on its own drive array since the RAID0 is a > disaster wating to happen. I said ideally a new dual AMD server with > 6/7-disk configuration would be ideal for safety and performance, but > they don't have $15K. I said a seperate drive array offer the balance > of safety and performance. > > I have been given budget of $7K to accomplish a safer/faster database > through hardware upgrades. The objective is to get a drive array, but > I can use the budget any way I see fit to accomplish the goal. You could build a dual opteron with 4 GB of ram, 12 10k raptor SATA drives with a battery backed cache for about 7k or less. Or if they are not CPU bound just IO bound you could easily just add an external 12 drive array (even if scsi) for less than 7k. Sincerely, Joshua D. Drake > > Since I am a dba novice, I did not physically build this server, nor > did I write the application the hospital runs on, but I have the > opportunity to make it better, I'd thought I should seek some advice > from those who have been down this road before. Suggestions/ideas > anyone? > > Thanks. > > Steve Poe > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------090105010705070105060205 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------090105010705070105060205--