Re: Reducing ClogControlLock contention

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Reducing ClogControlLock contention
Дата
Msg-id CAA4eK1JjRKsBkjkPWQkNFV+Eej==aSQRYerpWytRyy_s9OxQYA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reducing ClogControlLock contention  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On Tue, Jun 30, 2015 at 12:52 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>
> On 30 June 2015 at 08:13, Michael Paquier <michael.paquier@gmail.com> wrote:
>>
>>
>> Could it be possible to see some performance numbers? For example with a simple pgbench script doing a bunch of tiny transactions, with many concurrent sessions (perhaps hundreds).
>
>
> I'm more interested to see if people think it is safe.
>
> 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.
>

Exactly and other lock that can mask this improvement is WALWriteLock,
but for that we can take the performance data with synchronous_commit
off mode.



With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

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