Re: Sun Donated a Sun Fire T2000 to the PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: Robert(dot)Lor(at)Sun(dot)COM, pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Date: 2006-07-23 23:52:16
Message-ID: 28596.1153698736@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2006-07-24 00:06:23 Re: On-disk bitmap index patch
Previous Message Tom Lane 2006-07-23 23:43:35 Re: On-disk bitmap index patch

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Lor 2006-07-24 00:52:12 Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Previous Message Denis Lussier 2006-07-23 23:47:25 Re: postgres benchmarks