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 78D6F9FA508; Mon, 24 Jul 2006 00:35:13 -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 71216-05; Mon, 24 Jul 2006 00:35:06 -0300 (ADT) 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 9DD579FA48B; Mon, 24 Jul 2006 00:35:04 -0300 (ADT) Received: from d1-sfbay-04.sun.com ([192.18.39.114]) by nwkea-pix-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k6O3Z3n0017356; Sun, 23 Jul 2006 20:35:03 -0700 (PDT) Received: from conversion-daemon.d1-sfbay-04.sun.com by d1-sfbay-04.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J2V00A01YC5VR00@d1-sfbay-04.sun.com> (original mail from Robert.Lor@Sun.COM); Sun, 23 Jul 2006 20:35:02 -0700 (PDT) Received: from [192.168.1.67] ([71.142.94.24]) by d1-sfbay-04.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J2W00AFD1YDEH30@d1-sfbay-04.sun.com>; Sun, 23 Jul 2006 20:35:02 -0700 (PDT) Date: Sun, 23 Jul 2006 20:34:25 -0700 From: Robert Lor Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL In-reply-to: <29920.1153704579@sss.pgh.pa.us> To: Tom Lane Cc: Tatsuo Ishii , pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Message-id: <44C43FC1.4050002@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> <44C419BC.1050503@sun.com> <29920.1153704579@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.699 tagged_above=0 required=5 tests=AWL, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200607/232 X-Sequence-Number: 20092 Tom Lane wrote: >Hmmm ... AFAICS this must mean that flushing the WAL data to disk >at transaction commit time takes (most of) 20 msec on your hardware. >Which still seems high --- on most modern disks that'd be at least two >disk revolutions, maybe more. What's the disk hardware you're testing >on, particularly its RPM spec? > > I actually ran the test on my laptop. It has an Ultra ATA/100 drive (5400 rpm). The test was just a quickie to show some data from the probes. I'll collect and share data from the T2000 server later. Regards, -Robert