X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA0F1D82C0 for ; Fri, 18 Nov 2005 15:50:10 -0400 (AST) 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 81000-07 for ; Fri, 18 Nov 2005 19:50:10 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id F3335D6D50 for ; Fri, 18 Nov 2005 15:50:07 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 18 Nov 2005 13:50:07 -0600 Subject: Re: Suggested HW for postgres ? From: Scott Marlowe To: weigelt@metux.de Cc: pgsql-admin In-Reply-To: <20051118190550.GA16521@nibiru.local> References: <20051118190550.GA16521@nibiru.local> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1132343407.18317.6.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 18 Nov 2005 13:50:07 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/242 X-Sequence-Number: 19615 On Fri, 2005-11-18 at 13:05, Enrico Weigelt wrote: > Hi folks, > > > we're going to buy new hardware for an postgresql database server. > High availability is important, so I'm thinking of an > Athlon System w/ 2GB RAM and UW-SCSI RAID. > > But what hardware should I use ? > And what RAID configuration would be the best ? Generally, a good battery backed SCSI / SATA based RAID card is recommended, ECC memory, and a whole bunch of drives. RAID10 is favored for Transaction processing, RAID5 for large reporting databases is a good compromise of performance and $/megabyte. 64 bit CPUs are very nice to have, especially with a 64 bit OS on top of them. What are you planning on doing with pgsql? How big is your dataset, how many users will hit it at once, those kinds of things?