Re: Parallel queries for a web-application |performance testing

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: "Pierre C" <lists(at)peufeu(dot)com>
Cc: "Matthew Wakeling" <matthew(at)flymine(dot)org>, "Balkrishna Sharma" <b_ki(at)hotmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Parallel queries for a web-application |performance testing
Date: 2010-06-17 11:31:51
Message-ID: 87y6edj3o8.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Pierre C" <lists(at)peufeu(dot)com> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-06-17 14:58:36 Re: Query slow after analyse on postgresql 8.2
Previous Message Pierre C 2010-06-17 11:12:22 Re: Parallel queries for a web-application |performance testing