Buffermapping LWLock Contention

From: Amine Tengilimoglu <aminetengilimoglu(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Buffermapping LWLock Contention
Date: 2023-03-13 11:55:01
Message-ID: CADTdw-y54f2FO1xfkfqPEv_ygDnCKW55pATtuQwC=FHh16Xg6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi;

We have encountered a performance issue with buffermapping LWLock in
PG14.3(on CentOS7 ~ modern machine) .

Sometimes we see that the buffermaping wait event increases and
after a while all sessions are waiting for this lock (as far as we
understand there is a threshold value about buffermapping lwlock, all
sessions start to wait when it passes).

How did those who faced this problem go about? both on the database
side and the application side?

regards...

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-03-13 12:56:23 Re: Tooling for per table autovacuum tuning
Previous Message Alvaro Herrera 2023-03-13 10:09:36 Re: Tooling for per table autovacuum tuning