Re: Postgresql - Pgbouncer Connection and Query Performance Problem - Mailing list pgsql-admin

From Samed YILDIRIM
Subject Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Date
Msg-id CAAo1mbk1W6rcSUxJse_Uxr2xOBxHRhHkF8zf6wumYnV9s9ghLA@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql - Pgbouncer Connection and Query Performance Problem  (Abdullah Ergin <abdullaherginwork@gmail.com>)
List pgsql-admin
Hi Abdullah,

BufferIO and BufferMapping are different types of events than previous ones. Your server is probably suffering because of intensive IO operations. There can be big queries who are causing big read or write operations and/or a significant number of active connections. I would check it at the operating system level by using top command to see what is the percentage for IO Wait (wa), system (sy), and software interrupts (si).

Judging by PgBouncer configuration, I suspect that shared_buffers would be set to a huge number, proportional to the available memory. I would check this configuration too. You would want to check swap usage too.


Best regards.
Samed YILDIRIM


On Tue, 16 Apr 2024 at 18:41, Abdullah Ergin <abdullaherginwork@gmail.com> wrote:
Hello Samed,

Thank you for the information you provided about LWLocks. When I look at the type of these locks I see "BufferIO" and "BufferMapping" it really slows down the system. However, I have not yet fully understood what action I should take in this situation, especially why this situation is happening? and what should i do?

Best Regards.

pgsql-admin by date:

Previous
From: Abdullah Ergin
Date:
Subject: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Next
From: Siraj G
Date:
Subject: Re: Enable DB level audit trail