Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 705FE633D87
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  2 Feb 2010 17:59:59 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 02922-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  2 Feb 2010 21:59:35 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp113.plus.mail.re1.yahoo.com
	(smtp113.plus.mail.re1.yahoo.com [69.147.102.76])
	by mail.postgresql.org (Postfix) with SMTP id 8C4A8632D3A
	for <pgsql-performance@postgresql.org>;
	Tue,  2 Feb 2010 17:59:48 -0400 (AST)
Received: (qmail 45673 invoked from network); 2 Feb 2010 21:59:46 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type;
	b=q0o9Q/DSS3P9LroPEWIaqLghD4MNM/+SUwoyzAz2UZcMTEXwiDRomqegOMNQEMHs3qDvf4ouTONhBFb6DEcAF9tpQc3u9IbYAWK4BnKy0C1YUVwdJhsWbeAQO2z5UHGBbNtxuitxleJoJghVlSdQai0Qxr983um9JiEglck/dwI=
	;
Received: from booksys-207-111-162-65.booksys.com (rclemley@207.111.162.65
	with plain) by smtp113.plus.mail.re1.yahoo.com with SMTP;
	02 Feb 2010 13:59:46 -0800 PST
X-Yahoo-SMTP: 38zf3cmswBAUJ1LzNE6a.TW0Go34
X-YMail-OSG: 
 f8j3k3cVM1lQI.voa.pfPRaCe3fbwaA3J_KA2YKy6KCHHF89W7_CHxuXoCSEnfInp1rRZf2Im12IsMbVMDfDa95s9.5Iq0cYCbDN1I7abrOaTsIhPjHN_IHac92A3t8AKHM9zu1Fs6L76AAcUHkhIlTij3D9JtyS5KY4uF189Q9WnpPWQqP3M8CL794gd0zYXdsyLA05uXwhDE7kRl7SpNSoBeauIzd1L36olTtl6ImzeS6IkFZSHXBtg0JgT.TJUl0.uga4xvaJrnMNbVlxF0Pd_ePDzW6Rv2kSlXXaYl0riBjGPTMfLxiR4T9_IufVNo3ybkuL7zr.Am5sOzFE.dYvEOd5iTZEtxUKU60araVj.jRZg4GbVi0U_JRxjkk6cA5Ju5x.kg8aGiKLf02gh80ek1JZH88vKJ_Te2KAR.Dr9H53rI0uEz0plVZ.ht.pwgkemDzvgHDIb7FjAIA-
X-Yahoo-Newman-Property: ymail-3
Message-ID: <4B68A051.4030205@yahoo.com>
Date: Tue, 02 Feb 2010 15:59:45 -0600
From: Rob <rclemley@yahoo.com>
User-Agent: Icedove 1.5.0.14eol (X11/20090105)
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: pgsql-performance@postgresql.org
Subject: Re: System overload / context switching / oom, 8.3
References: <4B6878DF.3000004@yahoo.com>
	<4B6836E3020000250002EE82@gw.wicourts.gov>
In-Reply-To: <4B6836E3020000250002EE82@gw.wicourts.gov>
Content-Type: multipart/alternative;
	boundary="------------000205070003040601000901"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.597 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001
X-Spam-Level: 
X-Archive-Number: 201002/39
X-Sequence-Number: 37460

This is a multi-part message in MIME format.
--------------000205070003040601000901
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Kevin Grittner wrote:
> Rob <rclemley@yahoo.com> wrote:
>  
>   
>> 8gb ram
>> ~240 active databases
>> 800+ db connections via tcp.
>>     
>  
> 8 GB RAM divided by 800 DB connections is 10 MB per connection.  You
> seriously need to find some way to use connection pooling.  I'm not
> sure the best way to do that with 240 active databases.
>   

By wrangling the applications, We've got the number of connections down
to 530 and number of active databases down to 186.

The application's poor connection management exacerbates the problem.

Thanks for the idea,
Rob


--------------000205070003040601000901
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Kevin Grittner wrote:
<blockquote cite="mid4B6836E3020000250002EE82@gw.wicourts.gov"
 type="cite">
  <pre wrap="">Rob <a class="moz-txt-link-rfc2396E" href="mailto:rclemley@yahoo.com">&lt;rclemley@yahoo.com&gt;</a> wrote:
 
  </pre>
  <blockquote type="cite">
    <pre wrap="">8gb ram
~240 active databases
800+ db connections via tcp.
    </pre>
  </blockquote>
  <pre wrap=""><!----> 
8 GB RAM divided by 800 DB connections is 10 MB per connection.  You
seriously need to find some way to use connection pooling.  I'm not
sure the best way to do that with 240 active databases.
  </pre>
</blockquote>
<br>
By wrangling the applications, We've got the number of connections down
to 530 and number of active databases down to 186.<br>
<br>
The application's poor connection management exacerbates the problem.<br>
<br>
Thanks for the idea,<br>
Rob<br>
<br>
</body>
</html>

--------------000205070003040601000901--