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 71E5853358 for ; Sat, 26 Mar 2005 01:03:17 +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 24404-03 for ; Sat, 26 Mar 2005 01:03:10 +0000 (GMT) Received: from mail.ofsloans.com (mail.ofsloans.com [208.187.153.100]) by svr1.postgresql.org (Postfix) with ESMTP id 5303F5334D for ; Sat, 26 Mar 2005 01:03:09 +0000 (GMT) Message-ID: <4244B4C8.8010909@lashell.net> Date: Fri, 25 Mar 2005 18:03:04 -0700 From: Will LaShell 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: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/577 X-Sequence-Number: 11282 You can purchase a whole new dual opteron 740, with 6 gigs of ram, a case to match and 6 74 gig ultra320 sca drives for about $7k I know because that's what I bought one for 2 weeks ago. Using Tyan's dual board. If you need some details and are willing to go that route, let me know and I'll get you the information. Sincerely, Will LaShell 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. > > 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