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 E134452A43 for ; Thu, 12 May 2005 12:25:47 -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 63265-02 for ; Thu, 12 May 2005 15:25:39 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by svr1.postgresql.org (Postfix) with ESMTP id DCF965322D for ; Thu, 12 May 2005 12:25:35 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 12so892076nzp for ; Thu, 12 May 2005 08:25:35 -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:mime-version:content-type:content-transfer-encoding:content-disposition; b=Ui1BwqiWJH9A5emuaKhmOqC07hb5LdIimo0lBbqVwcxjemo6A2pL+sUPIUQxPks8QQHLp6qZtfcWrrgkH9rV+yzaIt1bB72ZXAuvrx2yWDiUMfbHLsXNL6iYWWCMhWSdcTk+mvwoPvGOLUktpO+3/+/p41Aip2kMau9NkaPIsGc= Received: by 10.36.154.6 with SMTP id b6mr666496nze; Thu, 12 May 2005 08:25:35 -0700 (PDT) Received: by 10.36.74.19 with HTTP; Thu, 12 May 2005 08:25:35 -0700 (PDT) Message-ID: <674d1f8a05051208252c67f6f6@mail.gmail.com> Date: Thu, 12 May 2005 20:55:35 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: pgsql-admin Subject: Help with connections Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.266 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200505/151 X-Sequence-Number: 17580 Guys i need some help. Initially the connections to the database were 3 as seen using netstat -a -n | grep "ESTAB" | grep and ps -ef | grep postgres After some time the connections suddenly incresed to 53 using the above commands. if i do=20 /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"; i get only=20 relname | datname | transaction | pid | mode | granted --------------------+----------------+-------------+-------+---------------= --+--------- pg_class | rpt_production | | 25903 | AccessShareLoc= k | t pg_locks | rpt_production | | 25903 | AccessShareLoc= k | t pg_class_oid_index | rpt_production | | 25903 | AccessShareLoc= k | t That means there were no tables accessed at this particular time. But why is the connections to database showing 53 ?. The Applicatoin is closing the connections. After about 30 -40 secs the connections drop to 4 or 5 agian. Please advice the max number of conenctions are 100 in the conf file .. how about increasing to 200 ?. --=20 Best, Gourish Singbal