"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > On 10/30/07, Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote: >> Some connection pools issue a BEGIN on the connection just >> after the previous user of the connection issues COMMIT and >> then closes it (Jboss does it). So, <IDLE> in transaction is not >> apriori bad. > You can turn off that behaviour, IIRC. It is broken behaviour as far > as pgsql is concerned, I believe. As of 8.3 it should be harmless, but in existing releases it's bad news. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend