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 9B1B43A4897 for ; Thu, 4 Nov 2004 17:25:07 +0000 (GMT) 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 46327-03 for ; Thu, 4 Nov 2004 17:25:05 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 81AFC3A488A for ; Thu, 4 Nov 2004 17:25:02 +0000 (GMT) Received: (qmail 8213 invoked from network); 4 Nov 2004 18:25:13 +0100 Received: from unknown (HELO musicbox) (boutiquenumerique-lists@192.168.0.2) by boutiquenumerique.com with SMTP; 4 Nov 2004 18:25:13 +0100 To: pgsql-performance@postgresql.org Subject: Re: Restricting Postgres References: <003001c4c28d$d2f16830$8300a8c0@solent> Message-ID: Date: Thu, 04 Nov 2004 18:25:16 +0100 From: =?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <003001c4c28d$d2f16830$8300a8c0@solent> User-Agent: Opera M2/7.54 (Linux, build 751) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/49 X-Sequence-Number: 9003 Myself, I like a small Apache with few modules serving static files (no dynamic content, no db connections), and with a mod_proxy on a special path directed to another Apache which generates the dynamic pages (few processes, persistent connections...) You get the best of both, static files do not hog DB connections, and the second apache sends generated pages very fast to the first which then trickles them down to the clients. >> Case in point: A first time visitor hits your home page. A >> dynamic page is generated (in about 1 second) and served >> (taking 2 more seconds) which contains links to 20 additional > > The gain from an accelerator is actually even more that that, as it takes > essentially zero seconds for Apache to return the generated content > (which > in the case of a message board could be quite large) to Squid, which can > then feed it slowly to the user, leaving Apache free again to generate > another page. When serving dialup users large dynamic pages this can be > a > _huge_ gain. > > I think Martin's pages (dimly recalling another thread) take a pretty > long > time to generate though, so he may not see quite such a significant gain. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match >