Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id EDC4C6329C3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 26 Aug 2010 17:29:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 66573-08
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 26 Aug 2010 20:29:39 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from ndjsnpf01.ndc.nasa.gov (ndjsnpf01.ndc.nasa.gov [198.117.1.121])
	by mail.postgresql.org (Postfix) with ESMTP id 406FE6329B6
	for <pgsql-performance@postgresql.org>;
	Thu, 26 Aug 2010 17:29:39 -0300 (ADT)
Received: from ndmsppt05.ndc.nasa.gov (ndmsppt05.ndc.nasa.gov [198.117.0.104])
	by ndjsnpf01.ndc.nasa.gov (Postfix) with ESMTP id E66E2328C34
	for <pgsql-performance@postgresql.org>;
	Thu, 26 Aug 2010 15:29:38 -0500 (CDT)
Received: from ndmshub02.ndc.nasa.gov (ndmshub02-pub.ndc.nasa.gov
	[198.117.0.161])
	by ndmsppt05.ndc.nasa.gov (8.14.3/8.14.3) with ESMTP id o7QKTWpS024854
	for <pgsql-performance@postgresql.org>; Thu, 26 Aug 2010 15:29:32 -0500
Received: from LRC000959195.larc.nasa.gov (198.119.134.170) by
	smtp02.ndc.nasa.gov (198.117.0.161) with Microsoft SMTP Server (TLS) id
	8.2.247.2; Thu, 26 Aug 2010 15:29:37 -0500
Message-ID: <4C76CEAB.1070308@nasa.gov>
Date: Thu, 26 Aug 2010 16:29:31 -0400
From: "Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>
Reply-To: Maria.L.Wilson-1@nasa.gov
Organization: SSAI
User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228)
MIME-Version: 1.0
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: [Fwd: postgres 8.4.1 number of connections]
Content-Type: multipart/alternative;
	boundary="------------030604080100020607040402"
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.0.10011,
 1.0.148,
	0.0.0000
	definitions=2010-08-26_14:2010-08-26, 2010-08-26,
	1970-01-01 signatures=0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.209 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201008/285
X-Sequence-Number: 40128

--------------030604080100020607040402
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit



-------- Original Message --------
Subject: 	postgres 8.4.1 number of connections
Date: 	Thu, 26 Aug 2010 14:25:47 -0500
From: 	Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
Reply-To: 	Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS 
APPLICATIONS] <m.l.wilson@nasa.gov>
To: 	pgsql-performance-owner@postgresql.org 
<pgsql-performance-owner@postgresql.org>



we have this application (using jboss/java/hibernate) on linux accessing 
data on 3 postgres database servers using 8.4.1. 

One of our many concerns has been the way we handle connections to the 
database.  java/hibernate handle their own pooling so I understand that 
using anything else is out of the question.  Our jboss configuration 
currently defaults to 5 connections per database.  On our main database 
server, we handle 7 of the databases that this application uses.  On 
this one server, we usually average around 300 - 500 connections to the 
server.  In our postgres conf file on this particular machine we set the 
max_connection parameter to 1000.  If we set it to much lower we end up 
with connection errors.  Any comments or better way to handle this?

thanks,  Maria Wilson
NASA, Langley Research Center
Hampton, Virginia 23666



--------------030604080100020607040402
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
 cellspacing="0">
  <tbody>
    <tr>
      <th align="right" nowrap="nowrap" valign="baseline">Subject: </th>
      <td>postgres 8.4.1 number of connections</td>
    </tr>
    <tr>
      <th align="right" nowrap="nowrap" valign="baseline">Date: </th>
      <td>Thu, 26 Aug 2010 14:25:47 -0500</td>
    </tr>
    <tr>
      <th align="right" nowrap="nowrap" valign="baseline">From: </th>
      <td>Maria L. Wilson <a class="moz-txt-link-rfc2396E" href="mailto:Maria.L.Wilson-1@nasa.gov">&lt;Maria.L.Wilson-1@nasa.gov&gt;</a></td>
    </tr>
    <tr>
      <th align="right" nowrap="nowrap" valign="baseline">Reply-To: </th>
      <td>Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS
APPLICATIONS] <a class="moz-txt-link-rfc2396E" href="mailto:m.l.wilson@nasa.gov">&lt;m.l.wilson@nasa.gov&gt;</a></td>
    </tr>
    <tr>
      <th align="right" nowrap="nowrap" valign="baseline">To: </th>
      <td><a class="moz-txt-link-abbreviated" href="mailto:pgsql-performance-owner@postgresql.org">pgsql-performance-owner@postgresql.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:pgsql-performance-owner@postgresql.org">&lt;pgsql-performance-owner@postgresql.org&gt;</a></td>
    </tr>
  </tbody>
</table>
<br>
<br>
<pre>we have this application (using jboss/java/hibernate) on linux accessing 
data on 3 postgres database servers using 8.4.1. 

One of our many concerns has been the way we handle connections to the 
database.  java/hibernate handle their own pooling so I understand that 
using anything else is out of the question.  Our jboss configuration 
currently defaults to 5 connections per database.  On our main database 
server, we handle 7 of the databases that this application uses.  On 
this one server, we usually average around 300 - 500 connections to the 
server.  In our postgres conf file on this particular machine we set the 
max_connection parameter to 1000.  If we set it to much lower we end up 
with connection errors.  Any comments or better way to handle this?

thanks,  Maria Wilson
NASA, Langley Research Center
Hampton, Virginia 23666

</pre>
</body>
</html>

--------------030604080100020607040402--