Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D6EA39FA3F2 for ; Fri, 2 Nov 2007 00:31:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 17988-01-5 for ; Fri, 2 Nov 2007 00:31:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 3DEF79FA3EC for ; Fri, 2 Nov 2007 00:31:04 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so580846ugf for ; Thu, 01 Nov 2007 20:31:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=SXWRA3wuOb2v+D0iRw8R+hbWvgvkl4LP3SoqrCM0z9w=; b=VULRyvHYIdc32BqL6i3xqgsgE/rfU3qXemboMTadUcGxzcjVH9K+zCK8MnfzlgR36p+M8RiZ205XRXibf2V8I6wQspkjTyjhf2N0JrUbL0XWcKQ/tA8yxTDKfWcjTEQwe2EnREVw596WgNXkqusHkyV/ntnJ3jOyHBGxyNQ8KJI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XJg0VTJ4zhgGDIfgcXUPmi9VByb1290aUjwHuY1XDvZ/QKqFnhZsAdEBd69eZ/Bn9EHp8Hoh/kH0Aqk2bOzSwsYsnMTGQXELraD6+Mer+n4Jz7yOLxuNgXZLODiPLPzKvnHzkWGCMXbe4ZMfgwMAZsZoQZSpsEaeVGGtncTGleA= Received: by 10.67.196.2 with SMTP id y2mr548681ugp.1193974263572; Thu, 01 Nov 2007 20:31:03 -0700 (PDT) Received: by 10.67.40.10 with HTTP; Thu, 1 Nov 2007 20:31:03 -0700 (PDT) Message-ID: Date: Thu, 1 Nov 2007 22:31:03 -0500 From: "Scott Marlowe" To: "Mark Floyd" Subject: Re: hardware for PostgreSQL Cc: pgsql-performance@postgresql.org In-Reply-To: <3B6F8084-0BD0-48C3-A6DB-C393FB4E5EFE@evryx.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3B6F8084-0BD0-48C3-A6DB-C393FB4E5EFE@evryx.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/28 X-Sequence-Number: 27443 On 11/1/07, Mark Floyd wrote: > Hello, > Dell PowerEdge Energy 2950 > (2) Quad Core Intel Xeon L5320, 2x4MB Cache, 1.86Ghz, 1066Mhz FSB > 4GB 667Mhz Dual Ranked DIMMs, Energy Smart > > PERC 5/i, x8 Backplane, Integrated Controller Card > > Hard Drive Configuration: Integrated SAS/SATA RAID1/Raid 5 > > Hard Drive 1 (For Operating System): 36GB 10K RPM SAS 3Gbps 2.5-in > Hot Plug HD > Hard Drive 2 (For logs): 36GB 10K RPM SAS 3Gbps 2.5-in Hot Plug HD > > Hard Drives 3,4,5,6 (In a RAID 5 Configuration): (4) 146GB 10K SAS > 3Gbps Hard Drive, 2-5 inch, Hot Plug If you can fit 8 drives in it, for the love of god add two more and mirror your OS and xlog drives ( I assume that's what you mean by drive 2 for logs). Running a server on non-redundant drives is not the best way to do things. And if you can live on ~ 300 Gigs of storage instead of 450 Gigs, look into RAID-10 for your data array. RAID 10 is noticeably faster than RAID-5 for any database that sees a fair bit of writing activity. > It's overkill for our initial system but we are shooting for a system > that allows for growth. If someone can let us know if we're on the > right path or are shooting ourselves in the foot with this setup I'd > appreciate it. Other than the 8 cores, it's not really overkill. And depending on your usage patterns 8 cores may well not be overkill too.