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 5A1029FA6B0;
	Fri, 21 Jul 2006 12:12:41 -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 66389-02; Fri, 21 Jul 2006 12:12:34 -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 DDF3A9FA50D;
	Fri, 21 Jul 2006 12:12:33 -0300 (ADT)
Received: from d1-sfbay-10.sun.com ([192.18.39.120])
	by nwkea-pix-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k6LFCW5v005094;
	Fri, 21 Jul 2006 08:12:32 -0700 (PDT)
Received: from conversion-daemon.d1-sfbay-10.sun.com by d1-sfbay-10.sun.com
	(Sun Java System Messaging Server 6.2-4.02 (built Sep  9 2005))
	id <0J2R00L01E789G00@d1-sfbay-10.sun.com>
	(original mail from Robert.Lor@Sun.COM);
	Fri, 21 Jul 2006 08:12:32 -0700 (PDT)
Received: from [129.150.12.121] by d1-sfbay-10.sun.com
	(Sun Java System Messaging Server 6.2-4.02 (built Sep  9 2005))
	with ESMTPSA id <0J2R00A0BE8V5670@d1-sfbay-10.sun.com>; Fri,
	21 Jul 2006 08:12:32 -0700 (PDT)
Date: Fri, 21 Jul 2006 08:11:58 -0700
From: Robert Lor <Robert.Lor@Sun.COM>
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
In-reply-to: <21889.1153489365@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>, pgsql-hackers@postgresql.org,
	pgsql-performance@postgresql.org
Message-id: <44C0EEBE.3030707@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>
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.787 tagged_above=0 required=5 tests=AWL,
	UNPARSEABLE_RELAY
X-Spam-Level: 
X-Archive-Number: 200607/210
X-Sequence-Number: 20070

Tom Lane wrote:

>Those numbers look a bit suspicious --- I'd expect to see some of the
>LWLocks being taken in both shared and exclusive modes, but you don't
>show any such cases. You sure your script is counting correctly?
>  
>
I'll double check to make sure no stupid mistakes were made!

>Also, it'd be interesting to count time spent holding shared lock
>separately from time spent holding exclusive.
>  
>
Will provide that data later today.

Regards,
-Robert