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

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?

Maxim Boguk wrote on 1/1/2023 11:51 AM:
>
>
> On Sun, Jan 1, 2023 at 6:43 PM MichaelDBA <MichaelDBA@sqlexec.com 
> <mailto:MichaelDBA@sqlexec.com>> wrote:
>
>     Hi Maxim,
>
>     10-20 active, concurrent connections is way below any CPU load
>     problem you should have with 48 available vCPUs.
>     You never explicitly said what the load is, so what is it in the
>     context of the 1,5,15?
>
>
> LA 10-15 all time, servers are really overprovisioned (2-3x by 
> available CPU resources) because an application is quite sensitive to 
> the database latency.
> And during these latency spikes - EXECUTE work without any issues 
> (e.g. only PARSE/BIND suck).
>
>
> -- 
> Maxim Boguk
> Senior Postgresql DBA
> https://dataegret.com/
>
> Phone UA: +380 99 143 0000
> Phone AU: +61  45 218 5678
>


Regards,

Michael Vitale

Michaeldba@sqlexec.com <mailto:michaelvitale@sqlexec.com>

703-600-9343