Re: Lock contention high - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Lock contention high
Date
Msg-id CAHOFxGqQBX46a+v4RyV5BBVY4wQ6m6p_mDzPw+vXQ+2Yz+Gdcw@mail.gmail.com
Whole thread Raw
In response to Re: Lock contention high  (Andres Freund <andres@anarazel.de>)
Responses Re: Lock contention high  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Lock contention high
Next
From: Andres Freund
Date:
Subject: Re: Lock contention high