24 Jul 2006 01:52
Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL
Tom Lane <tgl <at> sss.pgh.pa.us>
2006-07-23 23:52:16 GMT
2006-07-23 23:52:16 GMT
Tatsuo Ishii <ishii <at> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
RSS Feed