Hi
I control this way
if "state_change" is from longtime and "state" is idle then I use
function:
*pg_terminate_backend ( integer ) * ==> return TRUE if killed-successful
else FALSE
example:
# select pg_terminate_backend ( pid ) from pg_stat_activity where
state='idle' and state_change < (current_timestamp - interval '1 hour');
may be helpful
NOTE: we come to decision to kill sessions in idle state more then "1 hour"
after lot of discussion with application / implementation / stake-holders
team
*removed history as thrown error due to mail length
Thanks
Sridhar
OpenText