X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4219E9FB2F8 for ; Thu, 10 Aug 2006 15:00:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 38661-06 for ; Thu, 10 Aug 2006 15:00:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.225]) by postgresql.org (Postfix) with ESMTP id E0FC79FB235 for ; Thu, 10 Aug 2006 15:00:02 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so500683wxc for ; Thu, 10 Aug 2006 11:00:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=WY9IFzcxXj56ymXQeoCeHsd6v3Zoosd/6lu16tQJCl1gFeoZsd3iO9yD80wBUOT1lcN2TczLU/44nn00+1PtFB6muS9Gky40A4gb9vN1qsHcWWbA2BQzcSQ4ulgEGsz4k+gO1qZDHAygsADWVgAbL2YSi2YhqnvcToAV2LrGhu0= Received: by 10.78.142.14 with SMTP id p14mr1564881hud; Thu, 10 Aug 2006 10:59:59 -0700 (PDT) Received: by 10.78.32.10 with HTTP; Thu, 10 Aug 2006 10:59:59 -0700 (PDT) Message-ID: Date: Thu, 10 Aug 2006 12:59:59 -0500 From: "Aaron Bono" To: "Chris Mair" Subject: Re: Postgres Max JDBC Connection Allowed Cc: "Sharma,G.S." , pgsql-admin@postgresql.org In-Reply-To: <1155226774.5893.4.camel@dell.home.lan> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_56153_7571758.1155232799353" References: <002201c6bc94$7f7566e0$be05a8c0@ng3024> <1155226774.5893.4.camel@dell.home.lan> X-Google-Sender-Auth: 20bfee81cc4e9108 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.529 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/141 X-Sequence-Number: 22684 ------=_Part_56153_7571758.1155232799353 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/10/06, Chris Mair wrote: > > > > Hi, > > I am using Postgres 7.3 can any body tell me the max no of JDBC > > connections allowed by postgres . > > The maximum number of connections is a configuration variable in the > file postgresql.conf in your PGDATA dir. > Whether they origin from a JDBC driver or not is not relevant. > > > I also want to know how to find out that howmuch memory and CPU , > > my postgres is taking . > > Ask your operating system :) > top on unices or the tasklist on windows might be a start... Don't forget to check the ulimit for the postgres user. I had problems on a couple of our servers because the default for users was to limit their memory and number of processes. ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_56153_7571758.1155232799353 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/10/06, Chris Mair <chrisnospam@1006.org> wrote:

> Hi,
>     I am using Postgres 7.3 can any body tell me the max no of JDBC
> connections allowed by postgres .

The maximum number of connections is a configuration variable in the
file postgresql.conf in your PGDATA dir.
Whether they origin from a JDBC driver or not is not relevant.

>     I also want to know how to find out that howmuch memory and CPU ,
> my postgres is taking .

Ask your operating system :)
top on unices or the tasklist on windows might be a start...

 
Don't forget to check the ulimit for the postgres user.  I had problems on a couple of our servers because the default for users was to limit their memory and number of processes.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_56153_7571758.1155232799353--