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 <michael...@sqlexec.com
<mailto:michael...@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
michael...@sqlexec.com <mailto:michaelvit...@sqlexec.com>
703-600-9343
