Forum OpenACS Development: Re: OpenACS performance issues

Collapse
Posted by Dave Bauer on
I'd recommend increasing shared buffers to 128MB.

You need to take the aolserver down, and restart postgresql after making the change.

32MB is very small for a modern server with 4GB ram.

128mb shared buffers is the default recommended value for OpenACS.

Collapse
Posted by Matthew Coupe on
I tried to set it to 128MB but postgres wouldn't restart, I set it to 80MB and it restarted but then I couldn't get any sort of connection whatsoever to my site. Sounds strange? Is there a total memory value somewhere that I need to increase?
Collapse
Posted by Matthew Coupe on
From: https://openacs.org/xowiki/postgresql-admin

I take it we need to increase this value too?
What would you recommend?

#Change the kernel parameter for maximum shared memory segment size to 128Mb: DAVEB: How current is this? Do modern 2.4 or 2.6 kernels have such low settings? This is highly dependent also on the amount of RAM on your server, most realy servers have gigabytes of RAM so adjust accordingly.

[root root]# echo 134217728 >/proc/sys/kernel/shmmax
[root root]#

Make that change permanent by editing /etc/sysctl.conf to add these lines at the end:

# increase shared memory limit for postgres
kernel.shmmax = 134217728