Horton
Menu

Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)

Maxim Boguk <maxim.boguk@gmail.com>

View thread
From: Maxim Boguk <maxim.boguk@gmail.com>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>, pgsql-performance@lists.postgresql.org
Date: 2023-01-01T17:06:49Z
Lists: pgsql-performance 
On Sun, Jan 1, 2023 at 6:55 PM MichaelDBA <MichaelDBA@sqlexec.com> wrote:

> You said it's a dedicated server, but pgbouncer is running locally,
> right?  PGBouncer has a small footprint, but is the CPU high for it?
>

There are 4 pgbouncer processes in so_reuseport mode.
I never saw more than 40% of a single CPU core per one pgbouncer process
(most time under 20%).
So it's an unlikely result of pgbouncer being overloaded.


-- 
Maxim Boguk
Senior Postgresql DBA
https://dataegret.com/

Phone UA: +380 99 143 0000
Phone AU: +61  45 218 5678