X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1AEDE5406E for ; Thu, 28 Apr 2005 09:13:50 -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 89936-04 for ; Thu, 28 Apr 2005 12:13:41 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id 1CC3C53FE3 for ; Thu, 28 Apr 2005 09:13:37 -0300 (ADT) Received: from jefftrout.com ([24.61.201.181]) by comcast.net (sccrmhc12) with SMTP id <2005042812134101200dbedse>; Thu, 28 Apr 2005 12:13:41 +0000 Received: (qmail 36155 invoked from network); 28 Apr 2005 12:14:20 -0000 Received: from waltham-nat.ma.lycos.com (HELO ?10.124.7.194?) (209.202.205.1) by 192.168.0.109 with SMTP; 28 Apr 2005 12:14:20 -0000 In-Reply-To: <87r7gv3hrx.fsf@stark.xeocode.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509899C@vt-pe2550-001.vantage.vantage.com> <8764y83wg7.fsf@stark.xeocode.com> <87r7gv3hrx.fsf@stark.xeocode.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <2425e7a6ce717809d308bcc9591f6693@torgo.978.org> Content-Transfer-Encoding: 7bit Cc: "Anjan Dave" , From: Jeff Subject: Re: Why is this system swapping? Date: Thu, 28 Apr 2005 08:13:43 -0400 To: Greg Stark X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.182 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, RCVD_IN_SORBS_DUL X-Spam-Level: X-Archive-Number: 200504/759 X-Sequence-Number: 12156 On Apr 27, 2005, at 7:46 PM, Greg Stark wrote: > In fact I think it's generally superior to having a layer like pgpool > having > to hand off all your database communication. Having to do an extra > context > switch to handle every database communication is crazy. > I suppose this depends on how many machines / how much traffic you have. In one setup I run here I get away with 32 * 4 db connections instead of 500 * 4. Pretty simple to see the savings on the db machine. (Yes, it is a "bad design" as you said where static & dynamic content are served from the same box. However it also saves money since I don't need machines sitting around serving up pixel.gif vs myBigApplication.cgi) -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/