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

On Sun, Jan 1, 2023 at 6:55 PM MichaelDBA 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

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 > wrote: Hi Maxim, 10-20 active,

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

On Sun, Jan 1, 2023 at 6:43 PM MichaelDBA 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, ser

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

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? Maxim Boguk wrote on 1/1/2023 11:30 AM: 1)usual load (e.g. no anomalies) 10-20 con

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

On Sun, Jan 1, 2023 at 3:27 PM MichaelDBA wrote: > Howdy, > > Few additional questions: > >1. How many concurrent, active connections are running when these BIND >problems occur? select count(*) from pg_stat_activity where state in >('active','idle in transaction') >2. Are the qu

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

Howdy, Few additional questions: 1. How many concurrent, active connections are running when these BIND problems occur?  select count(*) from pg_stat_activity where state in ('active','idle in transaction') 2. Are the queries using gigantic IN () values? 3. Perhaps unrelated, but islog_tem

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

On Sat, Dec 31, 2022 at 4:32 PM Justin Pryzby wrote: > On Sat, Dec 31, 2022 at 02:26:08PM +0200, Maxim Boguk wrote: > > Hi, > > > > When performing post-mortem analysis of some short latency spikes on a > > heavily loaded database, I found that the reason for (less than 10 second > > latency spik