Hi,
We run our webserver using mod_perl and perl/DBI/DBD-Pg .
I have observed that most of the pg backends that block other queries
are in '<IDLE> in transaction' state. Usually sending a -INT or -TERM
to such blocking backends solve the problem.
My question is
1. Are there some precuation to be taken in perl/DBI programming
in mod_perl environment to avoid backends getting into '<IDLE> in
transaction'
mode?
2. Is it advisable/safe to run a daemon that TERMs such blocking backend
at regular interval.
3. Most Importantly , If a do not have access to to the host is it
possible to
TERMinate such backeds from psql>
Regds
Mallah.