|
The Idle-in transaction process will prevent VACUUM
from removing dead rows. I think you should have them fix the client such that
they dont issue a begin unless they need to do something on the
database. Also have the client commit as early as it can. It is safe to
leave the database connection idle, but dont leave it idle in a
transaction.
-Chandra Sekhar Surapaneni From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Rodrigo Sakai Sent: Wednesday, April 19, 2006 7:00 AM To: pgsql-admin@xxxxxxxxxxxxxx Subject: [ADMIN] IDLE IN TRANSACTION Hi,
I have an app developed with Delphi, and
when I just start tha app it start a process (a connection) on the db
server and the status stay 'IDLE IN TRANSACTION' until the end of the
application. The app is developed by other people and I don't know much about
how it was programmed! But I want to know if this kind of connection (idle in
transaction) can cause locks and deadlocks on the db? And if is there a better
way to connect to db?
Thanks in
advance!
|
