Re: [WIP PATCH] for Performance Improvement in Buffer Management
От | Pavan Deolasee |
---|---|
Тема | Re: [WIP PATCH] for Performance Improvement in Buffer Management |
Дата | |
Msg-id | CABOikdPEJ1KWce-FEgmVL1NiiUwRwfkTTwXkPzc7vyf3pFZ=ig@mail.gmail.com обсуждение исходный текст |
Ответ на | [WIP PATCH] for Performance Improvement in Buffer Management (Amit kapila <amit.kapila@huawei.com>) |
Ответы |
Re: [WIP PATCH] for Performance Improvement in Buffer
Management
|
Список | pgsql-hackers |
>Sorry, I haven't followed this thread at all, but the numbers (43171 and 57920) in the last two runs of @mv-free-list for 32 clients look aberrations, no ? I wonder if >that's skewing the average.
Yes, that is one of the main reasons, but in all runs this is consistent that for 32 clients or above this kind of numbers are observed.
Even Jeff has pointed the similar thing in one of his mails and suggested to run the tests such that first test should run “with patch” and then “without patch”.
After doing what he suggested the observations are still similar.
> I also looked at the the Results.htm file down thread. There seem to be a steep degradation when the shared buffers are increased from 5GB to 10GB, both with and
> without the patch. Is that expected ? If so, isn't that worth investigating and possibly even fixing before we do anything else ?
The reason for decrease in performance is that when shared buffers are increased from 5GB to 10GB, the I/O starts as after increasing it cannot hold all
the data in OS buffers.
В списке pgsql-hackers по дате отправления: