Re: [GENERAL] Debug advice when postgres connection maxing out

2010-11-24 Thread Robert Gravsjö
On 2010-11-23 20.56, anypossibility wrote: Thank you for your advice.I reviewed the query and it is the most simple one column value update with primary key query. I would like to share this with you and would like to receive advice as to whether I am on the right track. Facts: the connecti

Re: [GENERAL] Debug advice when postgres connection maxing out

2010-11-23 Thread Robert Gravsjö
On 2010-11-22 20.41, anypossibility wrote: Server: OS X 10.5 PostgreSQL version: 8.3 We experience this connection maxing out once in the full moon. The request from client reaches to the server but client never receive response back. The queries are very simple update on one record or selec

Re: [GENERAL] Debug advice when postgres connection maxing out

2010-11-22 Thread Jayadevan M
Hello, > > Server: OS X 10.5 > PostgreSQL version: 8.3 > > We experience this connection maxing out once in the full moon. > The request from client reaches to the server but client never > receive response back. > The queries are very simple update on one record or select one > record using p

[GENERAL] Debug advice when postgres connection maxing out

2010-11-22 Thread anypossibility
Server: OS X 10.5 PostgreSQL version: 8.3 We experience this connection maxing out once in the full moon. The request from client reaches to the server but client never receive response back. The queries are very simple update on one record or select one record using primary key (checked curre