Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 72EA3633723 for ; Thu, 17 Jun 2010 08:32:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 44572-08 for ; Thu, 17 Jun 2010 11:31:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mail.postgresql.org (Postfix) with ESMTP id 6FF6C632FD5 for ; Thu, 17 Jun 2010 08:31:54 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id BF66D93BAA; Thu, 17 Jun 2010 13:31:52 +0200 (CEST) Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id mkwrmLF3GKEZ; Thu, 17 Jun 2010 13:31:52 +0200 (CEST) Received: from mail1.hi-media-techno.com (unknown [192.168.27.17]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 7904E93B75; Thu, 17 Jun 2010 13:31:52 +0200 (CEST) Received: from dim (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTPSA id 1EFB46AD7C; Thu, 17 Jun 2010 13:31:52 +0200 (CEST) Received: by dim (Postfix, from userid 1000) id BEF0565917; Thu, 17 Jun 2010 13:31:51 +0200 (CEST) From: Dimitri Fontaine To: "Pierre C" Cc: "Matthew Wakeling" , "Balkrishna Sharma" , pgsql-performance@postgresql.org Subject: Re: Parallel queries for a web-application |performance testing Organization: Hi-Media References: User-Mail-Address: dfontaine@hi-media.com Date: Thu, 17 Jun 2010 13:31:51 +0200 In-Reply-To: (Pierre C.'s message of "Thu, 17 Jun 2010 13:12:22 +0200") Message-ID: <87y6edj3o8.fsf@hi-media-techno.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/309 X-Sequence-Number: 39165 "Pierre C" writes: > The same is true of a web server : 1000 active php interpreters (each eating > several megabytes or more) are not ideal for performance ! > > For php, I like lighttpd with php-fastcgi : the webserver proxies requests > to a small pool of php processes, which are only busy while generating the > page. Once the page is generated the webserver handles all (slow) IO to the > client. I use haproxy for that, it handles requests queues very effectively. -- dim