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

[MichaelDBA <MichaelDBA@xxxxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxx

703-600-9343