Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 694D963224F for ; Thu, 11 Feb 2010 13:49:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 86979-01-9 for ; Thu, 11 Feb 2010 17:48:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 8287E633C7D for ; Thu, 11 Feb 2010 13:48:43 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 11 Feb 2010 11:48:42 -0600 Message-Id: <4B73EE95020000250002F1CC@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 11 Feb 2010 11:48:37 -0600 From: "Kevin Grittner" To: "Jesper Krogh" , "Kevin Grittner" Cc: Subject: Re: moving pg_xlog -- yeah, it's worth it! References: <4B71358E020000250002F0E4@gw.wicourts.gov> <4B718BDB.8080807@krogh.cc> <4B7139DD020000250002F0E9@gw.wicourts.gov> In-Reply-To: <4B7139DD020000250002F0E9@gw.wicourts.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.468 tagged_above=-10 required=5 tests=AWL=0.131, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/189 X-Sequence-Number: 37610 "Kevin Grittner" wrote: > Jesper Krogh wrote: > >> Sorry if it is obvious.. but what filesystem/OS are you using and >> do you have BBU-writeback on the main data catalog also? > File system is xfs noatime,nobarrier for all data; OS is on ext3. > I *think* the pg_xlog mirrored pair is hanging off the same > BBU-writeback controller as the big RAID, but I'd have to track > down the hardware tech to confirm Another example of why I shouldn't trust my memory. Per the hardware tech: OS: /dev/sda is RAID1 - 2 x 2.5" 15k SAS disk pg_xlog: /dev/sdb is RAID1 - 2 x 2.5" 15k SAS disk These reside on a ServeRAID-MR10k controller with 256MB BB cache. data: /dev/sdc is RAID5 - 30 x 3.5" 15k SAS disk These reside on the DS3200 disk subsystem with 512MB BB cache per controller and redundant drive loops. At least I had the file systems and options right. ;-) -Kevin