Re: POC: Cache data in GetSnapshotData()
| От | Mithun Cy |
|---|---|
| Тема | Re: POC: Cache data in GetSnapshotData() |
| Дата | |
| Msg-id | CAD__OuhygfLox2grcL4=jyLjGMsLmPiWqCi05PwrbOoqzqNyYw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: POC: Cache data in GetSnapshotData() (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: POC: Cache data in GetSnapshotData()
|
| Список | pgsql-hackers |
On Thu, Mar 3, 2016 at 11:50 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>What if you apply both this and Amit's clog control log patch(es)? Maybe the combination of the two helps substantially more than either >one alone.
>What if you apply both this and Amit's clog control log patch(es)? Maybe the combination of the two helps substantially more than either >one alone.
I did the above tests along with Amit's clog patch. Machine :8 socket, 64 core. 128 hyperthread.
With clog changes, perf of caching the snapshot patch improves.| clients | BASE | ONLY CLOG CHANGES | % Increase | ONLY SAVE SNAPSHOT | % Increase | CLOG CHANGES + SAVE SNAPSHOT | % Increase |
| 64 | 29247.658034 | 30855.728835 | 5.4981181711 | 29254.532186 | 0.0235032562 | 32691.832776 | 11.7758992463 |
| 88 | 31214.305391 | 33313.393095 | 6.7247618606 | 32109.248609 | 2.8670931702 | 35433.655203 | 13.5173592978 |
| 128 | 30896.673949 | 34015.362152 | 10.0939285832 | *** | *** | 34947.296355 | 13.110221549 |
| 256 | 27183.780921 | 31192.895437 | 14.7481857938 | *** | *** | 32873.782735 | 20.9316056164 |
--
В списке pgsql-hackers по дате отправления: