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
2013/10/15 Svetlin Manavski
> 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 som
