X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CEF5453510 for ; Fri, 13 May 2005 10:21:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34041-04 for ; Fri, 13 May 2005 13:21:55 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by svr1.postgresql.org (Postfix) with ESMTP id 34D835296E for ; Fri, 13 May 2005 10:21:54 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 12so1415314nzp for ; Fri, 13 May 2005 06:21:55 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=iXn03cnqILiIvaUINDchEzvRKWh7IjoocoVYF2F7q2RXm8b4GpLnjuhGKn2JQTS/XyK7DxXztFRYD6HmzHFn7LxNZJQevJQ6YL4X1tDHhyTMyre5fajsStZNfJUTmNz2PxdhDS386M5ki6swUIjlQGy+Bge6Id/DMAKn8o85WeE= Received: by 10.36.154.16 with SMTP id b16mr1054676nze; Fri, 13 May 2005 06:21:55 -0700 (PDT) Received: by 10.36.74.10 with HTTP; Fri, 13 May 2005 06:21:55 -0700 (PDT) Message-ID: <674d1f8a05051306211f2f64bc@mail.gmail.com> Date: Fri, 13 May 2005 18:51:55 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: pgsql-admin Subject: Re: Help with connections In-Reply-To: <674d1f8a05051208252c67f6f6@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <674d1f8a05051208252c67f6f6@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.268 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200505/181 X-Sequence-Number: 17610 Found the problem. The Application opens the connections retrives the result set and does processing on the data based on certian logic and than closes the connections. But during the time application does processing the connections are open . thats the time i see 53 idle connections. regards Gourish On 5/12/05, Gourish Singbal wrote: > Guys i need some help. >=20 > Initially the connections to the database were 3 as seen using > netstat -a -n | grep "ESTAB" | grep > and ps -ef | grep postgres >=20 > After some time the connections suddenly incresed to 53 using the > above commands. >=20 > if i do > /usr/local/pgsql/bin/psql -d -c "select > c.relname,d.datname,transaction,pid,mode,granted from pg_locks > l,pg_class c,pg_database d where l.relation=3Dc.oid and > l.database=3Dd.oid"; >=20 > i get only > relname | datname | transaction | pid | mode > | granted > --------------------+----------------+-------------+-------+-------------= ----+--------- > pg_class | rpt_production | | 25903 | AccessShareLo= ck | t > pg_locks | rpt_production | | 25903 | AccessShareLo= ck | t > pg_class_oid_index | rpt_production | | 25903 | AccessShareLo= ck | t >=20 > That means there were no tables accessed at this particular time. But > why is the connections to database showing 53 ?. >=20 > The Applicatoin is closing the connections. After about 30 -40 secs > the connections drop to 4 or 5 agian. >=20 > Please advice the max number of conenctions are 100 in the conf file > .. how about increasing to 200 ?. >=20 > -- > Best, > Gourish Singbal >=20 --=20 Best, Gourish Singbal