Re: Proposal of tunable fix for scalability of 8.4 - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Proposal of tunable fix for scalability of 8.4
Date
Msg-id 49BE2E80.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Proposal of tunable fix for scalability of 8.4  (david@lang.hm)
Responses Re: Proposal of tunable fix for scalability of 8.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
<david@lang.hm> wrote:
> On Fri, 13 Mar 2009, Kevin Grittner wrote:
>> If all data access is in RAM, why can't 80 processes
>> keep 64 threads (on 8 processors) busy?  Does anybody else think
>> that's an interesting question, or am I off in left field here?
>
> I don't think that anyone is arguing that it's not intersting, but I
> also think that complete dismissal of the existing test case is also
> wrong.

Right, I just think this point in the test might give more targeted
results.  When you've got many more times the number of processes than
processors, of course processes will be held up.  It seems to me that
this is the point where the real issues are least likely to get lost
in the noise.  It also might point out delays from the clients which
would help in interpreting the results farther down the list.

One more reason this point is an interesting one is that it is one
that gets *worse* with the suggested patch, if only by half a percent.

Without:

600: 80: Medium Throughput: 82632.000 Avg Medium Resp: 0.005

with:

600: 80: Medium Throughput: 82241.000 Avg Medium Resp: 0.005

-Kevin

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Postgres benchmarking with pgbench
Next
From: "Mark Steben"
Date:
Subject: Performance of archive logging in a PITR restore