Forum OpenACS Development: Re: OpenACS performance issues
we have on our learn system more than 10 times the number of entries in the permission tables, and much better speed (most time below 1ms, with up to 2000 concurrently active users; but we have also a different hardware).
The indices you have are correct, these are the indices of the standard openacs installation.
We have on our productive environment two indices more:
Try to add these:
create index acs_privilege_descendant_map_privilege_idx on acs_privilege_descendant_map (privilege);after creating the indices, do a "VACUUM
create index acs_object_context_index_object_id_idx on acs_object_context_index (object_id);
measure again. It is a while, since i have added these indices. They might be an artefact of our local modifications. if they don't not help, remove the indices again.
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?
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?