Postgres Pro
Downloads
Home   >   mailing lists

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

From MichaelDBA
Subject Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Date
Msg-id 2f7a8841-71c7-03e7-1bd5-2b1f95d24c16@sqlexec.com
Whole thread Raw
In response to Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)  (Maxim Boguk <maxim.boguk@gmail.com>)
Responses Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)  (Maxim Boguk <maxim.boguk@gmail.com>)
List pgsql-performance
Tree view
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 is log_temp_files turned on, and if so, do you have a lot of logs related to that?

Regards,
Michael Vitale, just another PG DBA






pgsql-performance by date:

Previous
From: Maxim Boguk
Date:
Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Next
From: Maxim Boguk
Date:
Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)