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 8BD2B5280B for ; Wed, 8 Jun 2005 13:32: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 78461-10 for ; Wed, 8 Jun 2005 16:32:15 +0000 (GMT) Received: from campbell-lange.net (campbell-lange.net [217.147.82.41]) by svr1.postgresql.org (Postfix) with ESMTP id 472BC5289E for ; Wed, 8 Jun 2005 13:32:14 -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 1Dg3Th-0001sk-Dt for pgsql-performance@postgresql.org; Wed, 08 Jun 2005 17:32:29 +0100 Received: from rory by localhost.localdomain with local (Exim 4.50) id 1Dg3VS-0000rx-Oa for pgsql-performance@postgresql.org; Wed, 08 Jun 2005 17:34:18 +0100 Date: Wed, 8 Jun 2005 17:34:18 +0100 From: Rory Campbell-Lange To: pgsql-performance@postgresql.org Subject: Help specifying new web server/database machine Message-ID: <20050608163418.GA3327@campbell-lange.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/174 X-Sequence-Number: 12811 I'm tasked with specifying a new machine to run a web application prototype. The machine will be serving web pages with a Postgresql backend; we will be making extensive use of plpgsql functions. No database tables are likely to go over a million rows during the prototype period. We are considering two RAID1 system disks, and two RAID1 data disks. We've avoided buying Xeons. The machine we are looking at looks like this: Rackmount Chassis - 500W PSU / 4 x SATA Disk Drive Bays S2882-D - Dual Opteron / AMD 8111 Chipset / 5 x PCI Slots 2x - (Dual) AMD Opteron 246 Processors (2.0GHz) - 1MB L2 Cache/core (single core) 2GB (2x 1024MB) DDR-400 (PC3200) ECC Registered SDRAM (single rank) 4 Port AMCC/3Ware 9500-4LP PCI SATA RAID Controller 80GB SATA-150 7200RPM Hard Disk / 8MB Cache 80GB SATA-150 7200RPM Hard Disk / 8MB Cache 250GB SATA-150 7200RPM Hard Disk / 8MB Cache 250GB SATA-150 7200RPM Hard Disk / 8MB Cache Slimline 8x DVD / 24x CD-ROM Drive Standard 3yr (UK) Next Business Day On-site Warranty I would be grateful for any comments about this config. Kind regards, Rory -- Rory Campbell-Lange