| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [Re] Need help with postgresql/apache/php optimisation |
| Date: | 2004-02-18 23:26:54 |
| Message-ID: | 200402182326.54501.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 18 February 2004 21:35, Froggy / Froggy Corp. wrote:
>
> Another question, i put on postgresql.conf a limited number of
> postgresql max_connections, and use permanent link beetween apache and
> postgresql. The problem is that a lot of apache thread is used for
> sending data (gfx). Is there a way to say that some thread are only here
> for php process ?
Given your lack of memory, I'd drop the permanent (persistent) connections
between php and postgresql - connect for every page you need to. That should
free up some memory.
Once we have the vmstat figures, we can look at how to tune postgresql.conf
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-02-18 23:29:46 | Re: [Re] Need help with postgresql/apache/php optimisation |
| Previous Message | Martijn van Oosterhout | 2004-02-18 23:15:34 | Re: wishlist: dynamic log volume control |