Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 095319FB3D7 for ; Thu, 26 Jul 2007 17:02:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62046-02 for ; Thu, 26 Jul 2007 17:01:58 -0300 (ADT) X-Greylist: delayed 00:05:27.983846 by SQLgrey-1.7.5 Received: from sca-es-mail-1.sun.com (sca-es-mail-1.Sun.COM [192.18.43.132]) by postgresql.org (Postfix) with ESMTP id AF8129FB3B3 for ; Thu, 26 Jul 2007 17:01:57 -0300 (ADT) Received: from fe-sfbay-09.sun.com ([192.18.43.129]) by sca-es-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id l6QJuSpj009602 for ; Thu, 26 Jul 2007 12:56:28 -0700 (PDT) Received: from conversion-daemon.fe-sfbay-09.sun.com by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JLS00M01XZW7P00@fe-sfbay-09.sun.com> (original mail from Robert.Lor@Sun.COM) for pgsql-performance@postgresql.org; Thu, 26 Jul 2007 12:56:27 -0700 (PDT) Received: from [10.0.247.135] ([192.18.37.228]) by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JLS00IYHY23OC10@fe-sfbay-09.sun.com>; Thu, 26 Jul 2007 12:56:27 -0700 (PDT) Date: Thu, 26 Jul 2007 14:56:08 -0500 From: Robert Lor Subject: Re: User concurrency thresholding: where do I look? In-reply-to: <27577.1185464568@sss.pgh.pa.us> To: Tom Lane Cc: "Jignesh K. Shah" , Simon Riggs , Josh Berkus , pgsql-performance@postgresql.org, Alvaro Herrera Message-id: <46A8FC58.7060301@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: <200707190828.59088.josh@agliodbs.com> <200707191819.13899.josh@agliodbs.com> <15685.1184895926@sss.pgh.pa.us> <200707192138.39679.josh@agliodbs.com> <46A0FA31.2080208@sun.com> <12002.1184955831@sss.pgh.pa.us> <46A1055F.9010304@sun.com> <12445.1184958793@sss.pgh.pa.us> <46A11116.5030905@sun.com> <14909.1184962561@sss.pgh.pa.us> <46A1205B.8010205@sun.com> <15343.1184965054@sss.pgh.pa.us> <1185180668.4284.149.camel@ebony.site> <23848.1185199901@sss.pgh.pa.us> <1185201556.4284.243.camel@ebony.site> <25095.1185202498@sss.pgh.pa.us> <1185205663.4284.249.camel@ebony.site> <1185212261.4284.270.camel@ebony.site> <1545.1185214760@sss.pgh.pa.us> <46A7D5AD.9000706@sun.com> <13162.1185405865@sss.pgh.pa.us> <46A8AFDF.3050804@sun.com> <26825.1185460816@sss.pgh.pa.us> <46A8BD62.2080904@sun.com> <27577.1185464568@sss.pgh.pa.us> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/373 X-Sequence-Number: 26057 Tom Lane wrote: > > That path would be taking CLogControlLock ... so you're off by at least > one. Compare the script to src/include/storage/lwlock.h. > Indeed, the indexing was off by one due to the removal of BuffMappingLock in src/include/storage/lwlock.h between 8.1 and 8.2 which was not updated in the DTrace script. Thanks, Robert