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 B7B259FA508; Sun, 23 Jul 2006 21:53:11 -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 24195-01; Mon, 24 Jul 2006 00:53:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from nwkea-pix-1.sun.com (nwkea-pix-1.sun.com [192.18.42.249]) by postgresql.org (Postfix) with ESMTP id 8055C9FA48B; Sun, 23 Jul 2006 21:53:07 -0300 (ADT) Received: from d1-sfbay-03.sun.com ([192.18.39.113]) by nwkea-pix-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k6O0r0Nm011060; Sun, 23 Jul 2006 17:53:00 -0700 (PDT) Received: from conversion-daemon.d1-sfbay-03.sun.com by d1-sfbay-03.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J2V00401PLD4R00@d1-sfbay-03.sun.com> (original mail from Robert.Lor@Sun.COM); Sun, 23 Jul 2006 17:53:00 -0700 (PDT) Received: from [129.150.12.121] by d1-sfbay-03.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J2V004TGUG0CO20@d1-sfbay-03.sun.com>; Sun, 23 Jul 2006 17:53:00 -0700 (PDT) Date: Sun, 23 Jul 2006 17:52:12 -0700 From: Robert Lor Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL In-reply-to: <3706.1153678226@sss.pgh.pa.us> To: Tom Lane Cc: Tatsuo Ishii , pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Message-id: <44C419BC.1050503@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en References: <20060617.101521.95879771.t-ishii@sraoss.co.jp> <10226.1150511655@sss.pgh.pa.us> <20060617.111838.39487910.t-ishii@sraoss.co.jp> <20060713.180234.45872055.t-ishii@sraoss.co.jp> <8669.1153422118@sss.pgh.pa.us> <44C088C8.9050303@sun.com> <21889.1153489365@sss.pgh.pa.us> <44C195F8.9010409@sun.com> <3706.1153678226@sss.pgh.pa.us> User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.7) Gecko/20060307 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200607/230 X-Sequence-Number: 20090 Tom Lane wrote: >Yeah, those seem plausible, although the hold time for >CheckpointStartLock seems awfully high --- about 20 msec >per transaction. Are you using a nonzero commit_delay? > > > > I didn't change commit_delay which defaults to zero. Regards, -Robert