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

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