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

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Date: 2023-01-01 13:27:34
Message-ID: 2f7a8841-71c7-03e7-1bd5-2b1f95d24c16@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 (<big list>) values?
3. Perhaps unrelated, but islog_temp_files turned on, and if so, do you
have a lot of logs related to that?

Regards,
Michael Vitale, just another PG DBA

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maxim Boguk 2023-01-01 16:30:55 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Previous Message Maxim Boguk 2023-01-01 11:34:50 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)