X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D1F5C9FB37B for ; Tue, 22 Aug 2006 18:34:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 42466-02 for ; Tue, 22 Aug 2006 18:34:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from servata.com (ip-216-152-249-241.servata.com [216.152.249.241]) by postgresql.org (Postfix) with ESMTP id E30209FA4D9 for ; Tue, 22 Aug 2006 18:34:11 -0300 (ADT) Received: from [209.162.219.253] (helo=dogma.v10.wvs) by servata.com with esmtpa (Exim 4.50) id 1GFdss-0007fZ-JC for pgsql-performance@postgresql.org; Tue, 22 Aug 2006 14:34:06 -0700 Subject: PowerEdge 2950 questions From: Jeff Davis To: pgsql-performance@postgresql.org Content-Type: text/plain; charset=UTF-8 Date: Tue, 22 Aug 2006 14:34:08 -0700 Message-Id: <1156282448.15743.88.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.272 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200608/362 X-Sequence-Number: 20547 This question is related to the thread: http://archives.postgresql.org/pgsql-performance/2006-08/msg00152.php but I had some questions. I am looking at setting up two general-purpose database servers, replicated with Slony. Each server I'm looking at has the following specs: Dell PowerEdge 2950 - 2 x Dual Core Intel=C2=AE Xeon=C2=AE 5130, 4MB Cache, 2.00GHz, 1333MHZ FS= B - 4GB RAM - PERC 5/i, x6 Backplane, Integrated Controller Card (256MB battery- backed cache) - 6 x 73GB, SAS, 3.5-inch, 15K RPM Hard Drive arranged in RAID 10 These servers are reasonably priced and so they seem like a good choice for the overall price, and the above thread indicated good performance. However, I want to make sure that putting WAL in with PGDATA on the RAID-10 is wise. And if there are any other suggestions that would be great. Is the RAID controller good? Are the processors good for database work or are Opterons significantly better? I may go for more storage as well (i.e. getting 300GB disks), but I am still determining the potential need for storage. I can get more RAM at a later date if necessary also. Regards, Jeff Davis