Forum OpenACS Development: Re: OpenACS performance issues

Collapse
24: Re: OpenACS performance issues (response to 23)
Posted by Matthew Coupe on 03/06/08 05:01 PM
zen is no performance bottleneck, it won't affect the speed of permissions at all.

Sorry, I wasn't very clear. I was benchmarking against Zen to see if there are any extra expensive queries in my custom Zen template. Zen is a little faster but that is to be expected as our custom template is a little more complex.

I added the indices but there was little effect and some queries were still taking 240ms+.

Dave mentioned increasing Shared_Buffers from 32MB - I tried this but Postgresql wouldn't restart. What sort of value should I be going for here? Could this be the issue?

Collapse
26: Re: OpenACS performance issues (response to 24)
Posted by Gustaf Neumann on 03/06/08 06:19 PM
Seems twice as fast, but not really fast.
Have you set shmmax as indicated above? shmmax must be larger than the shared buffers, otherwise postgres won't start. note, that if you have multiple postgres servers running, you need memory for each server. What is the message, when postgres refuses to start?