Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1B6C52E0307 for ; Wed, 13 Feb 2008 09:12:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19441-04 for ; Wed, 13 Feb 2008 09:12:01 -0400 (AST) Received: from campbell-lange.net (campbell-lange.net [217.147.82.36]) by postgresql.org (Postfix) with ESMTP id 94A642E0310 for ; Wed, 13 Feb 2008 09:12:08 -0400 (AST) Received: from rory by campbell-lange.net with local (Exim 4.68) (envelope-from ) id 1JPHPC-000537-Nc for pgsql-performance@postgresql.org; Wed, 13 Feb 2008 13:12:06 +0000 Date: Wed, 13 Feb 2008 13:12:06 +0000 From: Rory Campbell-Lange To: PGSQL Performance Subject: Small DB Server Advice Message-ID: <20080213131206.GA18969@campbell-lange.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/132 X-Sequence-Number: 28674 We have a web application for which we intend to run the database on a dedicated server. We hope by the end of 2008 to have 10 companies accessing 10 instances of the database for this application. The dump file of each database is likely to be less than 100MB at the end of the year. The databases are read-heavy. I'm thinking of something along the following lines: (https://secure.dnuk.com/systems/r325hs-1u.php?configuration=7766) 4 x 147GB 15000 rpm SCSI in RAID 10 with 320-1 RAID CARD + 64MB cache BBU 2x Intel Xeon E5405 / 4x 2.00GHz / 1333MHz FSB / 12MB cache 6GB RAM Cost around 2320 GBP -- it would be great to get it under 2000 Needs to be in the UK. I would be grateful for any comments. I'm particularly out of date about the best processors to go for. DNUK also have Opteron as an option. Rory