On Fri, Mar 18, 2011 at 11:39 AM, tamanna madaan <tamanna.ma...@globallogic.com> wrote: > Thanks for your reply Merlin . > > If I am getting you correctly, you mean to say that I should check for > waiting queries in pg_stat_activity table > while my application is hung at SOCK_wait_for_ready function call . Right > ??
correct. let's hope the problem is here (look for waiting = true). Also take note of any sessions idle in transaction if there are any. > Yes I am opening multiple seesions with ODBC driver and my application is > multi threaded . The worst and possibly the most likely case is that you have some sort of threading/synchronization problem in your application or possibly the odbc driver itself. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
