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 A05F753799 for ; Fri, 15 Apr 2005 17:44:07 -0300 (ADT) 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 53219-06 for ; Fri, 15 Apr 2005 20:43:57 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by svr1.postgresql.org (Postfix) with ESMTP id 98FE3540C0 for ; Fri, 15 Apr 2005 17:43:57 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so1047327wra for ; Fri, 15 Apr 2005 13:43:54 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:x-mimeole:thread-index:message-id; b=q3e2p92gMVpPlzACwDWxN9M7J1WfkxzncpIdwFarVEDhyjctHnueSYfW4ogiwpLRr6SxQ/z22Nk7hwLZtosdzCCGfyYTZxAEVvaDHOzKz0SH9TyoGWMdSfPmZ3xXS5QTNyKgRvIyaVSvBMEfYR4JY5EBOjxk63GJtjYP+hQh8C8= Received: by 10.54.46.52 with SMTP id t52mr1975299wrt; Fri, 15 Apr 2005 13:43:49 -0700 (PDT) Received: from MATTSPC ([12.216.69.41]) by mx.gmail.com with ESMTP id 13sm41544wrl.2005.04.15.13.43.48; Fri, 15 Apr 2005 13:43:49 -0700 (PDT) Reply-To: From: "Matthew Nuzum" To: , "'Steve Poe'" Subject: Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How Date: Fri, 15 Apr 2005 15:43:47 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcVB+9HYWeMVlR8gQtODyE7UGXxEfQ== Message-ID: <42602785.602f27fb.2c70.0ad4@mx.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.304 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/363 X-Sequence-Number: 11760 I think there are many people who feel that $7,000 is a good budget for a database server, me being one. * I agree with the threads that more disks are better. * I also agree that SCSI is better, but can be hard to justify if your budget is tight, and I have great certainty that 2x SATA drives on a good controller is better than x SCSI drives for many work loads. * I also feel that good database design and proper maintenance can be one of the single biggest performance enhancers available. This can be labor intensive, however, and sometimes throwing more hardware at a problem is cheaper than restructuring a db. Either way, having a good hardware platform is an excellent place to start, as much of your tuning will depend on certain aspects of your hardware. So if you need a db server, and you have $7k to spend, I'd say spend it. From this list, I've gathered that I/O and RAM are your two most important investments. Once you get that figured out, you can still do some performance tuning on your new server using the excellent advice from this mailing list. By the way, for all those who make this list work, I've rarely found such a thorough, helpful and considerate group of people as these on the performance list. -- Matthew Nuzum www.followers.net - Makers of "Elite Content Management System" View samples of Elite CMS in action by visiting http://www.followers.net/portfolio/