From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
To: Sathish Reddy Yelala <sathishy040@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PGSQL-IDLE connection problem
Date: Tue, 29 Jan 2013 09:32:19 -0200
Message-ID: <5107B343.4070807@4linux.com.br> (raw)
In-Reply-To: <CAD4_txzfCHiMth-+ke0Gdkub1gi8m=M6kahdeK6SunzFujcC4g@mail.gmail.com>
References: <CAD4_txzfCHiMth-+ke0Gdkub1gi8m=M6kahdeK6SunzFujcC4g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@4linux.com.br
______________________________
FREE SOFTWARE SOLUTIONS
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: flavio@4linux.com.br, sathishy040@gmail.com
Subject: Re: PGSQL-IDLE connection problem
In-Reply-To: <5107B343.4070807@4linux.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox