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 EC696DA3E9 for ; Mon, 21 Nov 2005 16:36:20 -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 53741-07 for ; Mon, 21 Nov 2005 20:36:19 +0000 (GMT) X-Greylist: whitelisted by SQLgrey- Received: from ms-smtp-02.nyroc.rr.com (ms-smtp-02.nyroc.rr.com [24.24.2.56]) by svr1.postgresql.org (Postfix) with ESMTP id 85417DA2E5 for ; Mon, 21 Nov 2005 16:36:11 -0400 (AST) Received: from [192.168.1.101] (cpe-72-226-73-115.nycap.res.rr.com [72.226.73.115]) by ms-smtp-02.nyroc.rr.com (8.12.10/8.12.10) with ESMTP id jALKa6DK004648 for ; Mon, 21 Nov 2005 15:36:11 -0500 (EST) From: "Michael D. Sofka" To: pgsql-admin@postgresql.org Subject: Re: Server Hardware Configuration Date: Mon, 21 Nov 2005 15:36:24 -0500 User-Agent: KMail/1.8.2 References: <20051121171225.GU19279@pervasive.com> In-Reply-To: <20051121171225.GU19279@pervasive.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511211536.24683.sofkam@rpi.edu> X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/312 X-Sequence-Number: 19685 On Monday 21 November 2005 12:12, you wrote: > On Mon, Nov 21, 2005 at 09:41:36AM -0500, Michael D. Sofka wrote: > You're talking about a 16G database that you expect to grow to 64G. That > would fit happily in a RAID1 (mirror) of two SCSI 72G drives. I haven't > priced that kind of stuff out recently, but I believe you're looking at > $300-$500. If that doesn't provide enough performance, go to a RAID10 > and add more drives. If you're doing much writing at all, spring for a > battery-backed controller so you can enable write caching. More like $7k, till you add in the JBOD, the Perc card and 15,000 rpm SCSI disks, with hot spars (the journal mirror goes on the same JBOD). But you're right, we will have sufficient disks on the JBOD for RAID 1+0. Mike -- Michael D. Sofka sofkam@rpi.edu C&CT Sr. Systems Programmer Email, TeX, epistemology. Rensselaer Polytechnic Institute, Troy, NY. http://www.rpi.edu/~sofkam/