Howdy,
Few additional questions:
- 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')
- Are the queries using gigantic IN (<big list>) values?
- 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
|
