From ghanshyam@newgen.co.in Thu Aug 10 15:49:32 2006 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 7617B9FB2EF for ; Thu, 10 Aug 2006 12:49:32 -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 29874-03 for ; Thu, 10 Aug 2006 12:49:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by postgresql.org (Postfix) with SMTP id 9CED49FB25E for ; Thu, 10 Aug 2006 12:49:16 -0300 (ADT) Received: (qmail 23731 invoked by uid 507); 10 Aug 2006 15:49:13 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.1.3. Clear:RC:0(202.140.41.205):SA:0(-100.0/5.0):. Processed in 1.541161 secs); 10 Aug 2006 15:49:13 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 10 Aug 2006 15:49:12 -0000 Received: (qmail 13444 invoked by uid 504); 10 Aug 2006 15:49:03 -0000 Received: from ghanshyam@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.190):. Processed in 2.207148 secs); 10 Aug 2006 15:49:03 -0000 Received: from unknown (HELO ng3024) (192.168.5.190) by 192.168.5.243 with SMTP; 10 Aug 2006 15:49:00 -0000 Message-ID: <002201c6bc94$7f7566e0$be05a8c0@ng3024> From: "Sharma;G.S." To: Subject: Postgres Max JDBC Connection Allowed Date: Thu, 10 Aug 2006 21:19:00 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001F_01C6BCC2.991B5360" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.59 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, HTML_TEXT_AFTER_BODY X-Spam-Level: X-Archive-Number: 200608/137 X-Sequence-Number: 22680 This is a multi-part message in MIME format. ------=_NextPart_000_001F_01C6BCC2.991B5360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am using Postgres 7.3 can any body tell me the max no of JDBC = connections allowed by postgres . I also want to know how to find out that howmuch memory and CPU , my = postgres is taking . Thanks in advance =20 ------=_NextPart_000_001F_01C6BCC2.991B5360 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
    I am using Postgres = 7.3 can any=20 body tell me the max no of JDBC connections allowed by postgres = .
    I also want to know = how to find=20 out that howmuch memory and CPU , my postgres is taking .
 
Thanks in advance    =20    
 
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_001F_01C6BCC2.991B5360-- From chrisnospam@1006.org Thu Aug 10 16:19:56 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6E1C89FB1E9 for ; Thu, 10 Aug 2006 13:19:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 06539-01 for ; Thu, 10 Aug 2006 16:19:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from my.endian.it (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id 9A9549FA502 for ; Thu, 10 Aug 2006 13:19:44 -0300 (ADT) Received: from dell.home.lan (host188-110.pool874.interbusiness.it [87.4.110.188]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k7AGRRT24405; Thu, 10 Aug 2006 18:27:27 +0200 Subject: Re: Postgres Max JDBC Connection Allowed From: Chris Mair To: "Sharma;G.S." Cc: pgsql-admin@postgresql.org In-Reply-To: <002201c6bc94$7f7566e0$be05a8c0@ng3024> References: <002201c6bc94$7f7566e0$be05a8c0@ng3024> Content-Type: text/plain Date: Thu, 10 Aug 2006 18:19:34 +0200 Message-Id: <1155226774.5893.4.camel@dell.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-27) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/140 X-Sequence-Number: 22683 > 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... Bye, Chris. -- Chris Mair http://www.1006.org From postgresql@aranya.com Thu Aug 10 18:00:07 2006 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--