Re: [GENERAL] Idle transactions in PostgreSQL 9.2.4

2013-10-18 Thread Svetlin Manavski
Thanks Victor. The states were idle indeed but my application was not getting the results from that connections back. I have just found that there were 2 of the threads issuing queries to the same connection in parallel. That was the origin of the problem indeed. Best Regards, Svetlin Manavski

[GENERAL] Idle transactions in PostgreSQL 9.2.4

2013-10-17 Thread Svetlin Manavski
Hi all, I have some idle transactions in PostgreSQL 9.2.4 server which never end. My application was working fine on version 9.1 (BSD) but the problem appeared immediately as we ported it to 9.2.4 on Linux. The idle operations would frequently appear as COMMITs but sometimes I observed INSERTS as

Re: [GENERAL] Idle transactions in PostgreSQL 9.2.4

2013-10-17 Thread Victor Yegorov
2013/10/15 Svetlin Manavski svetlin.manav...@itrinegy.com I have some idle transactions in PostgreSQL 9.2.4 server which never end. My application was working fine on version 9.1 (BSD) but the problem appeared immediately as we ported it to 9.2.4 on Linux. The idle operations would frequently