Re: Optimizing Read-Only Scalability

Simon Riggs wrote:
> On Thu, 2009-05-14 at 16:21 -0700, Josh Berkus wrote:
>
>   
>>> So we can optimize away the scan through the procarray by doing two "if"
>>> tests, one outside of the lock, one inside. In normal running, both will
>>> be optimized away, though in read-only periods we would avoid much work.
>>>       
>> How much work would it be to work up a test patch?
>>     
>
> Not much. The most important thing is a place to test it and access to
> detailed feedback. Let's see if Dimitri does this.
>
> There are some other tuning aspects to be got right first also, but
> those are already known.
>
>   
I would be interested in testing it out.. I have been collecting some 
sysbench read-scalability numbers and some other numbers that I can cook 
up with dbt3 , igen.. So I have a frame of reference on those numbers .. 
I am sure we can always use some extra performance.

Regards,
Jignesh

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