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@xxxxxxxxxxxxx
______________________________
FREE SOFTWARE SOLUTIONS
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
