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 (<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