Re: Proposal of tunable fix for scalability of 8.4
| От | Tom Lane |
|---|---|
| Тема | Re: Proposal of tunable fix for scalability of 8.4 |
| Дата | |
| Msg-id | 12916.1236882481@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey <scott@richrelevance.com>) |
| Ответы |
Re: Proposal of tunable fix for scalability of 8.4
Re: Proposal of tunable fix for scalability of 8.4 |
| Список | pgsql-performance |
Scott Carey <scott@richrelevance.com> writes:
> They are not meaningless. It is certainly more to understand, but the test is entirely valid without that. In a CPU
bound/ RAM bound case, as concurrency increases you look for the throughput trend, the %CPU use trend and the context
switchrate trend. More information would be useful but the test is validated by the evidence that it is held up by
lockcontention.
Er ... *what* evidence? There might be evidence somewhere that proves
that, but Jignesh hasn't shown it. The available data suggests that the
first-order performance limiter in this test is something else.
Otherwise it should be possible to max out the performance with a lot
less than 1000 active backends.
regards, tom lane
В списке pgsql-performance по дате отправления: