From owner-freebsd-database Thu Apr 11 16: 9:28 2002 Delivered-To: freebsd-database@freebsd.org Received: from flake.decibel.org (flake.decibel.org [216.254.40.10]) by hub.freebsd.org (Postfix) with SMTP id 8EED437B405 for ; Thu, 11 Apr 2002 16:09:24 -0700 (PDT) Received: (qmail 8077 invoked by uid 1001); 11 Apr 2002 23:09:23 -0000 Date: Thu, 11 Apr 2002 18:09:23 -0500 From: "Jim C. Nasby" To: Francisco Reyes Cc: FreeBSD DB List Subject: Re: Raid configuration Message-ID: <20020411180923.O56810@flake.decibel.org> Reply-To: jim@nasby.net References: <20020329113017.L51218-100000@zoraida.natserv.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20020329113017.L51218-100000@zoraida.natserv.net>; from lists@natserv.com on Fri, Mar 29, 2002 at 11:33:16AM -0500 X-Operating-System: FreeBSD 4.5-STABLE i386 X-Distributed: Join the Effort! http://www.distributed.net Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Fri, Mar 29, 2002 at 11:33:16AM -0500, Francisco Reyes wrote: > Anyone has any experience with FreeBSD + RAID + SQL database? > In particular I am using PostgreSQL > > I am leaning towards RAID 10 with 4 disks > Given that PostgreSQL doesn't support table-spaces yet I would have the > first two mirrored disk for the database and the other two for the logs. > FWIW, RAID10 is not two seperate mirrors, it's a single volume. It's either a mirror of two striped volumes (yuck), or a stripe of mirrored volumes. In either case, it's not two seperately addressable volumes as your database v. logs comment suggests. -- Jim C. Nasby (aka Decibel!) jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message