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 BD2849FA2FB; Sat, 22 Jul 2006 00:06:18 -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 03772-04; Sat, 22 Jul 2006 03:06:08 +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 E0A2C9FA2DF; Sat, 22 Jul 2006 00:06:08 -0300 (ADT) Received: from d1-sfbay-02.sun.com ([192.18.39.112]) by nwkea-pix-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k6M362oT004002; Fri, 21 Jul 2006 20:06:02 -0700 (PDT) Received: from conversion-daemon.d1-sfbay-02.sun.com by d1-sfbay-02.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J2S000018LPX400@d1-sfbay-02.sun.com> (original mail from Robert.Lor@Sun.COM); Fri, 21 Jul 2006 20:06:02 -0700 (PDT) Received: from [129.150.12.121] by d1-sfbay-02.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J2S0008RBA1BB30@d1-sfbay-02.sun.com>; Fri, 21 Jul 2006 20:06:02 -0700 (PDT) Date: Fri, 21 Jul 2006 20:05:28 -0700 From: Robert Lor Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL In-reply-to: <21889.1153489365@sss.pgh.pa.us> To: Tom Lane Cc: Tatsuo Ishii , pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Message-id: <44C195F8.9010409@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 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> 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/218 X-Sequence-Number: 20078 Tom Lane wrote: >Also, it'd be interesting to count time spent holding shared lock >separately from time spent holding exclusive. > > > Tom, Here is the break down between exclusive & shared LWLocks. Do the numbers look reasonable to you? Regards, -Robert bash-3.00# time ./Tom_lwlock_acquire.d `pgrep -n postgres` ********** LWLock Count: Exclusive ********** Lock Id Mode Count ControlFileLock Exclusive 1 FreeSpaceLock Exclusive 9 XidGenLock Exclusive 202 CLogControlLock Exclusive 203 WALWriteLock Exclusive 203 BgWriterCommLock Exclusive 222 BufFreelistLock Exclusive 305 BufMappingLock Exclusive 305 ProcArrayLock Exclusive 405 FirstLockMgrLock Exclusive 670 WALInsertLock Exclusive 1616 ********** LWLock Count: Shared ********** Lock Id Mode Count CheckpointStartLock Shared 202 CLogControlLock Shared 450 SubtransControlLock Shared 776 XidGenLock Shared 2020 ProcArrayLock Shared 3778 SInvalLock Shared 4040 BufMappingLock Shared 40838 ********** LWLock Time: Exclusive ********** Lock Id Combined Time (ns) ControlFileLock 8301 FreeSpaceLock 80590 CLogControlLock 1603557 BgWriterCommLock 1607122 BufFreelistLock 1997406 XidGenLock 2312442 BufMappingLock 3161683 FirstLockMgrLock 5392575 ProcArrayLock 6034396 WALInsertLock 12277693 WALWriteLock 324869744 ********** LWLock Time: Shared ********** Lock Id Combined Time (ns) CLogControlLock 3183788 SubtransControlLock 6956229 XidGenLock 12012576 SInvalLock 35567976 ProcArrayLock 45400779 BufMappingLock 300669441 CheckpointStartLock 4056134243 real 0m24.718s user 0m0.382s sys 0m0.181s