Re: PGSQL-IDLE connection problem

Em 28-01-2013 07:12, Sathish Reddy Yelala escreveu:
> Hi,
>
> we had problem with <IDLE> connections.when we start the database
> there huge number of connections goes to <IDLE> which leads to database
> access slow.

These connections are opened by your client application, not by PostgreSQL.

> How can we prevent the <IDLE> connections and also where we can see
> the <IDLE> connection query so that we can identify.

You should consider looking at your application and how it handles the
connections it opens. What kind of application you have, distributed
clients or application server?

There's nothing to see about connections in <IDLE> state. They are doing
nothing, there's no query or transaction. They are just open connections.

Consider looking at the view pg_stat_activity. There you can see
username, IP and other things about these connections.

Regards,

__________________________________
Flavio Henrique A. Gurgel
Líder de Projetos Especiais
Consultoria, Projetos & Treinamentos 4LINUX
Tel1: +55-11.2125-4747 ou 2125-4748
www.4linux.com.br
email: flavio(at)4linux(dot)com(dot)br
______________________________
FREE SOFTWARE SOLUTIONS