Re: [ADMIN] PGSQL-IDLE connection problem

2013-01-30 Thread Albe Laurenz
Sathish Reddy Yelala wrote: > Thanks for the response.Here I have few more queries regarding > Connections. > > 1.When the connection goes to state When the server has completed a request and waits for the next one. > 2. when the connection becomes active When the server receives the n

Re: [ADMIN] PGSQL-IDLE connection problem

2013-01-29 Thread Sathish Reddy Yelala
hi, Thanks for the response.Here I have few more queries regarding Connections. 1.When the connection goes to state 2. when the connection becomes active 3.Is there any chance to database get slow because of connections Any help would be appreciated..

Re: [ADMIN] PGSQL-IDLE connection problem

2013-01-29 Thread Flavio Henrique Araque Gurgel
Em 28-01-2013 07:12, Sathish Reddy Yelala escreveu: Hi, we had problem with connections.when we start the database there huge number of connections goes to which leads to database access slow. These connections are opened by your client application, not by PostgreSQL. How can we

[ADMIN] PGSQL-IDLE connection problem

2013-01-28 Thread Sathish Reddy Yelala
Hi, we had problem with connections.when we start the database there huge number of connections goes to which leads to database access slow. How can we prevent the connections and also where we can see the connection query so that we can identify.