Re: Postgresql - Pgbouncer Connection and Query Performance Problem

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

To: Samed YILDIRIM <samed@xxxxxxxxxx>
Subject: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
From: Abdullah Ergin <abdullaherginwork@xxxxxxxxx>
Date: Tue, 16 Apr 2024 18:40:48 +0300
Cc: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAAo1mbkp2J9Z9r5ihxv=rU31YAAVo3381yT6VWp36Kt7JvNNKQ@mail.gmail.com>
References: <CAJZxWENRnzd4z_5HfTmU=PUnm-vRREmTA35ykj97KrJ5bRunzA@mail.gmail.com> <0adf6b95e08946113f12415e6f95fc74d2bc1a06.camel@cybertec.at> <CAJZxWEONnhdqr_76kkeQVLrjxRv-M6CxM7kyJvvLTmoscSuS_g@mail.gmail.com> <bf84d8ea3086056bcd19aa6fa04d9d894c7f8102.camel@cybertec.at> <CAAo1mbkp2J9Z9r5ihxv=rU31YAAVo3381yT6VWp36Kt7JvNNKQ@mail.gmail.com>

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.

Follow-Ups:
- Re: Postgresql - Pgbouncer Connection and Query Performance Problem
  - From: Samed YILDIRIM

References:
- Postgresql - Pgbouncer Connection and Query Performance Problem
  - From: Abdullah Ergin
- Re: Postgresql - Pgbouncer Connection and Query Performance Problem
  - From: Laurenz Albe
- Re: Postgresql - Pgbouncer Connection and Query Performance Problem
  - From: Abdullah Ergin
- Re: Postgresql - Pgbouncer Connection and Query Performance Problem
  - From: Laurenz Albe
- Re: Postgresql - Pgbouncer Connection and Query Performance Problem
  - From: Samed YILDIRIM

Prev by Date: Re: From CROSSTAB: One Column data with Two results columns
Next by Date: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Previous by thread: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Next by thread: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]