Re: POC: Cache data in GetSnapshotData()
| От | Mithun Cy |
|---|---|
| Тема | Re: POC: Cache data in GetSnapshotData() |
| Дата | |
| Msg-id | CAD__Ouic1Tvnwqm6Wf6j7Cz1Kk1DQgmy0isC7=OgX+3JtfGk9g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: POC: Cache data in GetSnapshotData() (Mithun Cy <mithun.cy@enterprisedb.com>) |
| Ответы |
Re: POC: Cache data in GetSnapshotData()
|
| Список | pgsql-hackers |
On Thu, Mar 10, 2016 at 1:36 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>Do you think it makes sense to check the performance by increasing CLOG buffers (patch for same is posted in Speed up Clog thread [1]) >as that also relieves contention on CLOG as per the tests I have done?
Along with clog patches and save snapshot, I also applied Amit's increase clog buffer patch. Below is the benchmark results.>Do you think it makes sense to check the performance by increasing CLOG buffers (patch for same is posted in Speed up Clog thread [1]) >as that also relieves contention on CLOG as per the tests I have done?
| clients | BASE | + WITH INCREASE IN CLOG BUFFER Patch | % Increase |
| 1 | 1198.326337 | 1275.461955 | 6.4369458985 |
| 32 | 37455.181727 | 41239.13593 | 10.102618726 |
| 64 | 48838.016451 | 56362.163626 | 15.4063324471 |
| 88 | 36878.187766 | 58217.924138 | 57.8654691695 |
| 128 | 35901.537773 | 58239.783982 | 62.22086182 |
| 256 | 28130.354402 | 56417.133939 | 100.5560723934 |
--
Thanks and Regards
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: