Re: Lock contention high

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Lock contention high
Дата
Msg-id CAHOFxGqQBX46a+v4RyV5BBVY4wQ6m6p_mDzPw+vXQ+2Yz+Gdcw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Lock contention high  (Andres Freund <andres@anarazel.de>)
Ответы Re: Lock contention high  (Andres Freund <andres@anarazel.de>)
Список pgsql-performance
On Mon, Oct 25, 2021, 5:36 PM Andres Freund <andres@anarazel.de> wrote:
If your hot data set is actually larger than s_b, I'd recommend trying a
larger s_b. It's plausible that a good chunk of lock contention is from that.


How much larger might you go? Any write ups on lock contention as it relates to shared buffers? How impactful might huge pages (off, transparent or on) be to the use of shared buffers and the related locking mechanism?

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Lock contention high
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Lock contention high