Re: Lock contention high

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Oct 25, 2021, 5:36 PM Andres Freund <andres@xxxxxxxxxxx> 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?

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux