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
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!