Josh Berkus wrote:
> Particularly, the difficulty is that this application gets many small
> requests during the day (100 simultaneous uses) and shares a server
> with Apache. So I have to be concerned about how much memory each
> connection soaks up, during the day. At night, the maintainence
Joe,
> I think we'd need more information to be of any help -- schema,
> functions, explain output, etc.
Yeah, I know. I'm just looking for general tips here ... I need to do
the actual optimization interactively.
Particularly, the difficulty is that this application gets many small
reque
Josh Berkus wrote:
> The problem: The update series (done as a function) takes 10-15
> minutes. During this time, the CPU is never more than 31% busy, only
> 256mb of 512 is in use, and the disk channel is only 25% - 50%
> saturated.As such, is seems like we could run things faster.
>
> What
