Buffermapping LWLock Contention - Mailing list pgsql-admin

From Amine Tengilimoglu
Subject Buffermapping LWLock Contention
Date
Msg-id CADTdw-y54f2FO1xfkfqPEv_ygDnCKW55pATtuQwC=FHh16Xg6g@mail.gmail.com
Whole thread Raw
List 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...

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Tooling for per table autovacuum tuning
Next
From: Ron
Date:
Subject: Re: Tooling for per table autovacuum tuning