Re: Reducing ClogControlLock contention

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Reducing ClogControlLock contention
Дата
Msg-id CANP8+j+ATdC18wqUPR0zk__5GgkH4L7naqmOzOO-NRrP_fuUsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reducing ClogControlLock contention  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 30 June 2015 at 08:22, Simon Riggs <simon@2ndquadrant.com> wrote:
 
This contention is masked by contention elsewhere, e.g. ProcArrayLock, so the need for testing here should come once other patches ahead of this are in.

Let me explain more clearly.

Andres' patch to cache snapshots and reduce ProcArrayLock was interesting, but not initially compelling. We now have a solution that commits in batches, which will reduce the number of times the ProcArray changes - this will heighten the benefit from Andres' snapshot cache patch.

So the order of testing/commit should be

Queued commit patch
ProcArray cache patch
Clog shared commit patch (this one)

I didn't hear recent mention of Robert's chash patch, but IIRC it was effective and so we hope to see it again soon also.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Reducing ClogControlLock contention
Следующее
От: Rahila Syed
Дата:
Сообщение: [PROPOSAL] VACUUM Progress Checker.