Hi all, I have a little problem, Every once in a while I observe that our filesystem is running out of space due to an continous growth of our transaction logs. After inspecting the backend processes I see that three of the type: idle in transaction. And that all of our nightly vacuum runs since the "idle in transaction" is waiting with an: VACUUM waiting.
Is there any way of finding out exactly what the "idle in transaction" transactions have issued so far? What DB / logins etc. they are associated with? Regards, Niclas Gustafsson ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
