I have recently noticed that there are ~22 postmaster processes that are "idle
in transaction". They are definitely caused from a web/Apache process, but I
can't figure out how to track down the cause. The pg_stat_activity table
shows them, but the current_query is empty. I've seen several questions
asked about this, but no definitive responses.
I saw from a posting to another list that someone suggested setting
$dbh->{AutoCommit} = 1;
immediately after doing a commit. Is this the proper way to code it? Would
not changing the AutoCommit flag cause the "idle in transaction" processes?
I don't think these were showing up before because I had not enabled the
Apache::DBI during startup.
This is for Postgres 7.3.2_1 on a FBSD system.
TIA.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Urchin Software Corp. http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~