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 49BE3DC3.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Proposal of tunable fix for scalability of 8.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Proposal of tunable fix for scalability of 8.4
List pgsql-performance
I wrote:
> 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

Oops.  A later version:

> Redid the test with - waking up all waiters irrespective of shared,
> exclusive

> 600: 80: Medium Throughput: 82920.000 Avg Medium Resp: 0.005

The one that showed the decreased performance at 800 was:

> a modified Fix (not the original one that I proposed but something
> that works like a heart valve : Opens and shuts to minimum
> default way thus  controlling how many waiters are waked up )

-Kevin

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Postgres benchmarking with pgbench
Next
From: Scott Carey
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4