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 7028A9FA5D8; Fri, 16 Jun 2006 23:34:24 -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 14711-02; Fri, 16 Jun 2006 23:34:17 -0300 (ADT) 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 980DB9FA5F8; Fri, 16 Jun 2006 23:34: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 k5H2YFvr010227; Fri, 16 Jun 2006 22:34:15 -0400 (EDT) To: Tatsuo Ishii 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.101521.95879771.t-ishii@sraoss.co.jp> References: <4492CBE2.3090509@sun.com> <20060617.101521.95879771.t-ishii@sraoss.co.jp> Comments: In-reply-to Tatsuo Ishii message dated "Sat, 17 Jun 2006 10:15:21 +0900" Date: Fri, 16 Jun 2006 22:34:15 -0400 Message-ID: <10226.1150511655@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/362 X-Sequence-Number: 19719 Tatsuo Ishii 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. 18% in s_lock is definitely bad :-(. Were you able to determine which LWLock(s) are accounting for the contention? The test case seems to be spending a remarkable amount of time in LIKE comparisons, too. That probably is not a representative condition. regards, tom lane