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
| GB wal_buffers | 128kB work_mem | 18MB Thank you, Svetlin Manavski