To optimize some of the parameters in the postgresql.conf file was changed
1) shared_buffers :24MB changed to 4GB calculation : 25% of system memory
2) A parameter effective cache size was added and it's value was set to 8GB.
3) To increase the shared buffer size the kernel shared memory was increased from 32MB to 4GB this was done by giving the following command on the shell prompt
sysctl -w kernel.shmmax=4289200128
to make the change persistent the sysctl.conf file was edited and the following value was added to it
kernel.shmmax=4289200128
""" There is not a drastic change in the speed of the platform , but the user experience would be slightly better than before
"""
We would like to migrate the beta site from HBCSE to the amsterdam server , we require some details of the server (alpesh would be writing to david regarding this in a short while. )