X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3054E9FB1FE for ; Mon, 14 Aug 2006 14:05:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 60283-04 for ; Mon, 14 Aug 2006 14:05:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 1EED99FB283 for ; Mon, 14 Aug 2006 14:05:47 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 4440956435; Mon, 14 Aug 2006 12:05:47 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 14 Aug 2006 12:05:46 -0500 Date: Mon, 14 Aug 2006 12:05:46 -0500 From: "Jim C. Nasby" To: Steve Poe Cc: pgsql-performance@postgresql.org Subject: Re: Postgresql Performance on an HP DL385 and Message-ID: <20060814170545.GG27928@pervasive.com> References: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com> <721b21dc0608082245u6ee62e7dg522ff18e4d72683@mail.gmail.com> <20060809210539.GR40481@pervasive.com> <1155180553.13315.0.camel@amd64-gentoo-laptop> <20060810110935.GF2900@mathom.us> <20060814153841.GF27928@pervasive.com> <721b21dc0608140851v2332cdf9g59808004c983540f@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <721b21dc0608140851v2332cdf9g59808004c983540f@mail.gmail.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060814:steve.poe@gmail.com::ddV+WOnwtTFuTfDI:000000000000000000 0000000000000000000000009dB3 X-Hashcash: 1:20:060814:pgsql-performance@postgresql.org::14ufliCK4mHF2bu1:00000 0000000000000000000000004GoV X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.117 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/213 X-Sequence-Number: 20398 On Mon, Aug 14, 2006 at 08:51:09AM -0700, Steve Poe wrote: > Jim, > > I have to say Michael is onto something here to my surprise. I partitioned > the RAID10 on the SmartArray 642 adapter into two parts, PGDATA formatted > with XFS and pg_xlog as ext2. Performance jumped up to median of 98 TPS. I > could reproduce the similar result with the LSI MegaRAID 2X adapter as well > as with my own 4-disc drive array. > > The problem lies with the HP SmartArray 6i adapter and/or the internal SCSI > discs. Putting the pg_xlog on it kills the performance. Wow, interesting. IIRC, XFS is lower performing than ext3, so if your previous tests were done with XFS, that might be part of it. But without a doubt, if you don't have a good raid controller you don't want to try combining pg_xlog with PGDATA. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461