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 C95739FB2B5 for ; Wed, 16 Aug 2006 06:13:14 -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 03862-04 for ; Wed, 16 Aug 2006 09:13:10 +0000 (UTC) X-Greylist: delayed 00:20:25.555633 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 39D2A9FB1C8 for ; Wed, 16 Aug 2006 06:13:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.mnc.ch (62-2-77-205.static.cablecom.ch [62.2.77.205]) by svr4.postgresql.org (Postfix) with ESMTP id 3D5CE5AF881 for ; Wed, 16 Aug 2006 08:52:42 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by mail.mnc.ch (Postfix) with ESMTP id 88B7BA82ED; Wed, 16 Aug 2006 10:57:21 +0200 (CEST) Received: from mail.mnc.ch ([127.0.0.1]) by localhost (mail.test.lan [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id 31383-05; Wed, 16 Aug 2006 10:57:19 +0200 (CEST) Received: from meuh.mnc.lan (62-2-77-204.static.cablecom.ch [62.2.77.204]) by mail.mnc.ch (Postfix) with ESMTP id 29066A82F3; Wed, 16 Aug 2006 10:57:19 +0200 (CEST) Received: by meuh.mnc.lan (Postfix, from userid 1000) id 14D98183663; Wed, 16 Aug 2006 10:52:25 +0200 (CEST) To: "Luke Lonergan" Cc: pgsql-performance@postgresql.org Subject: Re: Postgresql Performance on an HP DL385 and References: X-Hashcash: 1:20:060816:llonergan@greenplum.com::+eQJ7Tb2zl7sxo02:000000000000000000000000000000000000001VbI X-Hashcash: 1:20:060816:pgsql-performance@postgresql.org::t8x6h0YAzwM22Baa:000000000000000000000000000004kEI From: Guillaume Cottenceau Date: 16 Aug 2006 10:52:25 +0200 In-Reply-To: Message-ID: <87psf1rrjq.fsf@meuh.mnc.lan> Lines: 18 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: amavisd-new at mnc.ch X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/262 X-Sequence-Number: 20447 Hi, > Can you run bonnie++ version 1.03a on the machine and report the results > here? Do you know if the figures from bonnie++ are able to measure the performance related to the overhead of the 'fsync' option? I had very strange performance differences between two Dell 1850 machines months ago, and raw performance (hdparm, not bonnie++) was similar, the only figure I could find with a significant difference able to explain the issue was the "await" compound reported by "iostat" - but I was still very much in the dark :/ http://archives.postgresql.org/pgsql-performance/2006-03/msg00407.php -- Guillaume Cottenceau Create your personal SMS or WAP Service - visit http://mobilefriends.ch/