Re: Proposal of tunable fix for scalability of 8.4

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Proposal of tunable fix for scalability of 8.4
Дата
Msg-id 49BE3DC3.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Proposal of tunable fix for scalability of 8.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Proposal of tunable fix for scalability of 8.4  (Scott Carey <scott@richrelevance.com>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Postgres benchmarking with pgbench
Следующее
От: Scott Carey
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4