From owner-freebsd-questions@FreeBSD.ORG Fri Jun 4 13:53:29 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D07D416A4CE for ; Fri, 4 Jun 2004 13:53:29 -0700 (PDT) Received: from ns1.kenjim.com (brigitte.rhuidean.net [66.93.142.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9532D43D2D for ; Fri, 4 Jun 2004 13:53:29 -0700 (PDT) (envelope-from kenji@ns1.kenjim.com) Received: from ns1.kenjim.com (localhost.kenjim.com [127.0.0.1]) by ns1.kenjim.com (8.12.6/8.12.6) with ESMTP id i54Kqif3000325; Fri, 4 Jun 2004 13:52:44 -0700 (PDT) (envelope-from kenji@ns1.kenjim.com) Received: (from kenji@localhost) by ns1.kenjim.com (8.12.6/8.12.6/Submit) id i54KqiLT000324; Fri, 4 Jun 2004 13:52:44 -0700 (PDT) Date: Fri, 4 Jun 2004 13:52:44 -0700 From: Kenji M To: Charles Swiger Message-ID: <20040604205244.GA228@kenjim.com> References: <20040603214253.GA93387@kenjim.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i cc: kenji@kenjim.com cc: freebsd-questions@freebsd.org Subject: Re: Running FreeBSD/PostgreSQL on high-end dual Xeon box X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 04 Jun 2004 20:53:29 -0000 Thanks guys! After doing some additional reading and your comments I think staying with FreeBSD coupled with a good RAID controller would probably be the least hassle, reliable, and good performing setup. I am looking at a dual Xeon box using an Adpatec 2200S RAID controller with the write buffer backup battery module. We will also probably install 4GB of ram. Now the new question is which RAID level would provide the best balance of performance and reliability... I currently have a similar setup that has RAID 0+1 with one hot spare ready in case of mirror disk failure. I had been considering the same setup, but it might make sense just to use 3 disk RAID5 with hot spare ready. The new RAID controller implementation might not buy us much by using 0+1 vs. 5. Any thoughts? -Kenji On Thu, Jun 03, 2004 at 06:40:07PM -0400, Charles Swiger wrote: > On Jun 3, 2004, at 5:42 PM, Kenji M wrote: > >I am currently specing a 2U dual Xeon server and hope to use > >RAID 0+1 capability. The question is for PostgreSQL admins... > > > >1) Which RAID controller should we use? > > You haven't mentioned whether you plan to use SCSI or IDE drives. The > PERC RAID controller in Dell's PowerEdge's works quite well for the > former, but you might consider the 3ware twe if you're doing IDE. > > >2) Considering Q1, does it not even make sense to use > >FreeBSD+PostgreSQL > >and bite the bullet and go with Linux (assuming it has better hw RAID > >support) and run PostgreSQL on that using a fancier journaling > >filesystem. > > Hmm. What makes you think that a journalling filesystem gains you much > when you are running a database? > > Databases do their own transaction management using two-phase commit > and logfiles for rollback in case of a crash using a few very large > files, which they'll write to directly using async/directIO (whatever > the term you wish to use is), rather than using OS/filesystem > buffering.... > > -- > -Chuck -- +++++++++++++++++++++ kenji morishige kenji@kenjim.com http://www.kenjim.com +++++++++++++++++++++