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
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
TERMinate such backeds from psql>
pgsql-admin by date
|Next:||From: Rajesh Kumar Mallah||Date: 2004-10-25 05:54:44|
|Subject: Re: Upgrading to 7.4.5|
|Previous:||From: aditya s||Date: 2004-10-25 02:21:26|
|Subject: pgsql replicator|