On 18 Aug 2005, at 18:58, Jonathan Vanasco wrote:
i'm thinking about moving to pgsql for stored procedures too (yes my5 has it, but its beta), but thats an entirely OT discussion.
And you have pgpool too. But you're still trying to optimise prematurely. Treat your fat apaches as application servers and have few enough that if they're all running, they max out your CPU. For example, I have a MaxClients of 2 on one box that only renders Template::Toolkit, but 10 on a server where the PHP has to wait for a few SQL requests to come back. Oh, and in this situation, consider running separate apaches for your different applications. Tune your startup.pl for maximum sharing, keep MaxClients low and therefore your memory usage predictable.
