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 D5F409FA508;
	Sun, 23 Jul 2006 20:52:26 -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 01005-06; Sun, 23 Jul 2006 23:52:18 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 02E6E9FA48B;
	Sun, 23 Jul 2006 20:52:17 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k6NNqG5S028597;
	Sun, 23 Jul 2006 19:52:16 -0400 (EDT)
To: Tatsuo Ishii <ishii@sraoss.co.jp>
cc: Robert.Lor@Sun.COM, pgsql-hackers@postgresql.org,
	pgsql-performance@postgresql.org
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL 
In-reply-to: <20060617.111838.39487910.t-ishii@sraoss.co.jp> 
References: <4492CBE2.3090509@sun.com>
	<20060617.101521.95879771.t-ishii@sraoss.co.jp>
	<10226.1150511655@sss.pgh.pa.us>
	<20060617.111838.39487910.t-ishii@sraoss.co.jp>
Comments: In-reply-to Tatsuo Ishii <ishii@sraoss.co.jp>
	message dated "Sat, 17 Jun 2006 11:18:38 +0900"
Date: Sun, 23 Jul 2006 19:52:16 -0400
Message-ID: <28596.1153698736@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/229
X-Sequence-Number: 20089

Tatsuo Ishii <ishii@sraoss.co.jp> writes:
>>> Interesting. We (some Japanese companies including SRA OSS,
>>> Inc. Japan) did some PG scalability testing using a Unisys's big 16
>>> (physical) CPU machine and found PG scales up to 8 CPUs. However
>>> beyond 8 CPU PG does not scale anymore. The result can be viewed at
>>> "OSS iPedia" web site (http://ossipedia.ipa.go.jp). Our conclusion was
>>> PG has a serious lock contention problem in the environment by
>>> analyzing the oprofile result.

Can you retry this test case using CVS tip?  I'm curious to see if
having partitioned the BufMappingLock helps ...

			regards, tom lane