From owner-freebsd-amd64@FreeBSD.ORG Fri Sep 2 00:40:22 2005 Return-Path: X-Original-To: freebsd-amd64@freebsd.org Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A145F16A421 for ; Fri, 2 Sep 2005 00:40:22 +0000 (GMT) (envelope-from neuhauser@sigpipe.cz) Received: from isis.sigpipe.cz (fw.sigpipe.cz [62.245.70.224]) by mx1.FreeBSD.org (Postfix) with ESMTP id B94EB43D48 for ; Fri, 2 Sep 2005 00:40:21 +0000 (GMT) (envelope-from neuhauser@sigpipe.cz) Received: by isis.sigpipe.cz (Postfix, from userid 1001) id 346EC1F87BEF; Fri, 2 Sep 2005 02:40:20 +0200 (CEST) Date: Fri, 2 Sep 2005 02:40:20 +0200 From: Roman Neuhauser To: Norberto Meijome Message-ID: <20050902004020.GB6640@isis.sigpipe.cz> References: <4316A5BC.1000405@meijome.net> <20050901075851.GA19900@intserv.int1.b.intern> <4316B906.50002@meijome.net> <20050901135131.GB3805@isis.sigpipe.cz> <43179DAC.2010102@meijome.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43179DAC.2010102@meijome.net> User-Agent: Mutt/1.5.9i Cc: freebsd-amd64@freebsd.org Subject: Re: Which SCHED_ for DB server X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Sep 2005 00:40:22 -0000 # freebsd@meijome.net / 2005-09-02 10:32:44 +1000: > Roman Neuhauser wrote: > ># freebsd@meijome.net / 2005-09-01 18:17:10 +1000: > > > >>Holger Kipp wrote: > >> > >>>Hello, > >>> > >> > >>>>4 x SATA 150 drives, 90% of it RAID5 with gvinum. > >>> > >>> > >>>I do not know your applications, but if writing to disk is an issue: > >>> > >>>- WAL-files should be written to physically separated disks. > >> > >>sorry, what do you mean by WAL-files > > > > > > Looks like you might greatly benefit from getting acquainted with > > PostgreSQL first; you won't be able to tune anything if you don't > > know how the software works. > > > > touche. I've been reading from the documentation from their site and I > haven't seen anything on the WAL files...google helped a lot ;) http://www.postgresql.org/docs/8.0/static/wal.html > I think i'll go with 2 separate raid 1 instances given this > information (and cross the bridge of more storage needed when I get to > it). That sounds reasonable. Good luck with PostgreSQL! -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991