Re: Postgresql - Pgbouncer Connection and Query Performance Problem
От
Samed YILDIRIM
Тема
Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Дата
Msg-id
CAAo1mbk1W6rcSUxJse_Uxr2xOBxHRhHkF8zf6wumYnV9s9ghLA@mail.gmail.com
Ответ на
Re: Postgresql - Pgbouncer Connection and Query Performance Problem (Abdullah Ergin)
Список
Дерево обсуждения
[MASSMAIL]Postgresql - Pgbouncer Connection and Query Performance Problem Abdullah Ergin <abdullaherginwork@gmail.com>
Re: Postgresql - Pgbouncer Connection and Query Performance Problem Laurenz Albe <laurenz.albe@cybertec.at>
Re: Postgresql - Pgbouncer Connection and Query Performance Problem Abdullah Ergin <abdullaherginwork@gmail.com>
Re: Postgresql - Pgbouncer Connection and Query Performance Problem Laurenz Albe <laurenz.albe@cybertec.at>
Re: Postgresql - Pgbouncer Connection and Query Performance Problem Samed YILDIRIM <samed@reddoc.net>
Re: Postgresql - Pgbouncer Connection and Query Performance Problem Abdullah Ergin <abdullaherginwork@gmail.com>
Re: Postgresql - Pgbouncer Connection and Query Performance Problem Samed YILDIRIM <samed@reddoc.net>
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 по дате отправления
От: Abdullah Ergin
Дата:
