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 C2F4652825 for ; Thu, 9 Jun 2005 13:42:25 -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 58734-09 for ; Thu, 9 Jun 2005 16:42:19 +0000 (GMT) Received: from campbell-lange.net (campbell-lange.net [217.147.82.41]) by svr1.postgresql.org (Postfix) with ESMTP id C8DF552822 for ; Thu, 9 Jun 2005 13:42:18 -0300 (ADT) Received: from host-83-146-33-145.bulldogdsl.com ([83.146.33.145] helo=localhost.localdomain) by localhost.localdomain with esmtpa (Exim 4.50) id 1DgQ6z-0004dK-9W; Thu, 09 Jun 2005 17:42:33 +0100 Received: from rory by localhost.localdomain with local (Exim 4.50) id 1DgQ8j-0002py-0D; Thu, 09 Jun 2005 17:44:21 +0100 Date: Thu, 9 Jun 2005 17:44:20 +0100 From: Rory Campbell-Lange To: William Yu Cc: pgsql-performance@postgresql.org Subject: Re: Help specifying new web server/database machine Message-ID: <20050609164420.GA3649@campbell-lange.net> References: <20050608163418.GA3327@campbell-lange.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/218 X-Sequence-Number: 12855 Hi All. Thanks very much for Joshua, William, Bjoern and Matthew's replies. I've now looked at the famous "Server for 7K" thread. In my case we are looking for a server for around 3000 pounds (UK); the server is to be an all-purpose web and database server. Processor: First of all I noted that we were intending to use Opteron processors. I guess this isn't a straightforward choice because I believe Debian (our Linux of choice) doesn't have a stable AMD64 port. However some users on this list suggest that Opterons work very well even in a 32 bit environment. Some have suggested that a single dual core processor is the way to go. The RAM needs to fit the CPU arrangement too; William points out that one needs 2 DIMMS per CPU. Disks: I'm somewhat confused here. I've followed the various notes about SATA vs SCSI and it seems that SCSI is the way to go. On a four-slot 1U server, would one do a single RAID10 over 4 disks 10000rpm U320 disks? I would run the database in its own partition, separate from the rest of the OS, possible on LVM. An LSI-Megaraid-2 appears to be the card of choice. The following (without RAID card) breaks my budget by about 200 pounds: System : Armari Opteron AM-2138-A8 1U Base PCI-X (BEI) Case Accessories : IPMI 2.0 module for AM Series Opteron Servers CPU : AMD Opteron 265 - Dual Core 1.8GHz CPU (940pin) Memory : 2GB 400MHz DDR SDRAM (4 x 512MB (PC3200) ECC REG.s) Hard drive : Maxtor Atlas 10K V 147.1GB 10K U320/SCA - 8D147J0 Additional Drives : 3 x Maxtor Atlas 10K V 147.1GB 10K U320/SCA - 8D147J0 CD/DVD Drive : AM series Server 8x Slimline DVD-ROM Warranty : 3 Year Return to base Warranty (Opteron Server) Carriage : PC System Carriage (UK only) for 1U Server Thanks for any further comments, Rory -- Rory Campbell-Lange