X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 27DBE476398 for ; Thu, 10 Apr 2003 05:58:48 -0400 (EDT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id 13B83476393 for ; Thu, 10 Apr 2003 05:58:46 -0400 (EDT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h3A9wlF06691 for ; Thu, 10 Apr 2003 15:28:47 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h3A9wla06685 for ; Thu, 10 Apr 2003 15:28:47 +0530 From: Shridhar Daithankar To: "'Pgsql-Performance'" Subject: Re: Caching (was Re: choosing the right platform) Date: Thu, 10 Apr 2003 15:29:05 +0530 User-Agent: KMail/1.5 References: <000601c2fefe$d4b07e80$6900a8c0@mattspc> <20030410103435.B16757@ph.ed.ac.uk> In-Reply-To: <20030410103435.B16757@ph.ed.ac.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200304101529.05217.shridhar_daithankar@nospam.persistent.co.in> X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/106 X-Sequence-Number: 1612 On Thursday 10 April 2003 15:04, you wrote: > On Wed, Apr 09, 2003 at 09:16:36PM -0400, Matthew Nuzum wrote: > > Thanks for all the feedback, this is very informative. > > > > Here are some of the performance suggestions I've heard, please, if I > > mis-understood, could you help me get clarity? > > * It's better to run fewer apache children and turn off persistent > > connections (I had suggested 200 children per server, someone else > > suggested 40) > > Hi Matthew, > > I'm coming in a bit late and slightly OT here, but one common Apache > solution you might want to look at is a "reverse proxy" configuration. > This works very well if there's a good proportion of static vs dynamic > content on your site - if your pages contain a lot of graphics then this > may well be the case. > > To do this, you compile 2 Apache servers listening on different ports on Umm.. AFAIK, if you use fastCGI, persistence of connection should be a lot better and or OAS Server, which gives you explicit control on how much resources to allocate. Shridhar