X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 1A9BA9FB3F9 for ; Fri, 18 Aug 2006 15:14:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 90971-01-2 for ; Fri, 18 Aug 2006 18:12:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exprod6og52.obsmtp.com (exprod6og52.obsmtp.com [64.18.1.185]) by postgresql.org (Postfix) with SMTP id 061E89FB3EE for ; Fri, 18 Aug 2006 15:09:49 -0300 (ADT) Received: from source ([63.240.6.44]) by exprod6ob52.postini.com ([64.18.5.12]) with SMTP; Fri, 18 Aug 2006 11:09:45 PDT Received: from 172.16.1.148 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Fri, 18 Aug 2006 14:09:35 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 18 Aug 2006 14:09:29 -0400 Received: from 63.80.24.130 ([63.80.24.130]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.134]) with Microsoft Exchange Server HTTP-DAV ; Fri, 18 Aug 2006 18:09:29 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Fri, 18 Aug 2006 11:09:27 -0700 Subject: Re: Postgresql Performance on an HP DL385 and From: "Luke Lonergan" To: "Steve Poe" cc: "Scott Marlowe" , "Michael Stone" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Postgresql Performance on an HP DL385 and Thread-Index: AcbC8XFGr5jF3i7kEduD2wAWy4o9DA== In-Reply-To: <721b21dc0608181039x28012fednbeba47c5c4511661@mail.gmail.com> MIME-Version: 1.0 X-OriginalArrivalTime: 18 Aug 2006 18:09:29.0836 (UTC) FILETIME=[72F762C0:01C6C2F1] X-WSS-ID: 68F8DDD53FW3250986-03-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.5 tagged_above=0 required=5 tests=RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200608/305 X-Sequence-Number: 20490 Steve, On 8/18/06 10:39 AM, "Steve Poe" wrote: > Nope. it is only a RAID1 for the 2 internal discs connected to the SmartArray > 6i. This is where I *had* the pg_xlog located when the performance was very > poor. Also, I just found out the default stripe size is 128k. Would this be a > problem for pg_xlog? ISTM that the main performance issue for xlog is going to be the rate at which fdatasync operations complete, and the stripe size shouldn't hurt that. What are your postgresql.conf settings for the xlog: how many logfiles, sync_method, etc? > The 6-disc RAID10 you speak of is on the SmartArray 642 RAID adapter. Interesting - the seek rate is very good for two drives, are they 15K RPM? - Luke