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

From Dimitri Fontaine
Subject Re: Parallel queries for a web-application |performance testing
Date
Msg-id 87y6edj3o8.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: Parallel queries for a web-application |performance testing  ("Pierre C" <lists@peufeu.com>)
List pgsql-performance
"Pierre C" <lists@peufeu.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

pgsql-performance by date:

Previous
From: "Pierre C"
Date:
Subject: Re: Parallel queries for a web-application |performance testing
Next
From: Tom Lane
Date:
Subject: Re: Query slow after analyse on postgresql 8.2