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
