MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Date: Sun, 15 Mar 2009 16:40:04 -0400
From: "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Subject: Re: Proposal of tunable fix for scalability of 8.4
In-reply-to: <1E9C2E4B-4C0C-4343-B244-388DA2047870@decibel.org>
To: decibel <decibel@decibel.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Scott Carey <scott@richrelevance.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Message-id: <49BD67A4.7020106@sun.com>
References: <C5DDBB25.3333%scott@richrelevance.com>
	<29836.1236826066@sss.pgh.pa.us> <49B8861C.2000005@sun.com>
	<1E9C2E4B-4C0C-4343-B244-388DA2047870@decibel.org>
User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209)


decibel wrote:
> On Mar 11, 2009, at 10:48 PM, Jignesh K. Shah wrote:
>> Fair enough..  Well I am now appealing  to all  who has a fairly 
>> decent sized hardware want to try it out  and see whether there are 
>> "gains", "no-changes" or "regressions" based on your workload. Also 
>> it will help if you report number of cpus when you respond back to 
>> help collect feedback.
>
>
> Do you have a self-contained test case? I have several boxes with 
> 16-cores worth of Xeon with 96GB I could try it on (though you might 
> not care about having "only" 16 cores :P)
I dont have authority over iGen, but I am pretty sure that with sysbench 
we should be able to recreate the test case or even dbt-2
That said the patch should be pretty easy to apply to your own workloads 
(where more feedback is more appreciated ).. On x64 16 cores might bring 
out the problem faster too since typically they are 2.5X higher clock 
frequency..   Try it out.. stock build vs patched builds.


-Jignesh

-- 
Jignesh Shah           http://blogs.sun.com/jkshah  			
The New Sun Microsystems,Inc   http://sun.com/postgresql