=== modified file 'src/docbkx/en/dhis2_implementation_guide_installation.xml' --- src/docbkx/en/dhis2_implementation_guide_installation.xml 2013-06-05 19:43:40 +0000 +++ src/docbkx/en/dhis2_implementation_guide_installation.xml 2013-06-06 20:16:48 +0000 @@ -85,14 +85,14 @@ Do performance tuning by opening the following file by invoking sudo nano /etc/postgresql/9.2/main/postgresql.conf and set the following properties: - shared_buffers = 2400MB - Determines how much memory PostgreSQL can use for caching of data. This setting controls - how the size of the kernel shared memory which should be reserved for PostgreSQL. Should be - set to around 30% of total memory designated for PostgreSQL. + shared_buffers = 3200MB + Determines how much memory should be allocated exclusively for PostgreSQL caching. This + setting controls the size of the kernel shared memory which should be reserved for PostgreSQL. + Should be set to around 40% of total memory dedicated for PostgreSQL. work_mem = 20MB Determines the amount of memory used for internal sort and hash operations. This setting - is per connection, per query so a lot of memory may be consumed if raising this too - high. + is per connection, per query so a lot of memory may be consumed if raising this too high. + Setting this value correctly is essential for DHIS 2 aggregation performance. maintenance_work_mem = 256MB Determines the amount of memory PostgreSQL can use for maintenance operations such as creating indexes, running vacuum, adding foreign keys. Incresing this value might improve @@ -278,17 +278,19 @@ }]]>
- Enabling caching and SSL on nginx + Enabling caching, compression and SSL on nginx Requests for reports, charts, maps and other analysis-related resources will often take some time to respond and might utilize a lot of server resources. In order to improve response times, reduce the load on the server and hide potential server downtime we can introduce a cache proxy in our server setup. The cached content will be stored in directory /var/cache/nginx, and up to 250 MB of storage will be allocated. Nginx will create this - directory automatically. + directory automatically. It is also useful to enable compression of data which is returned + by nginx in order to reduce the size of data that has to be transferred over the network. http { # ... root /home/dhis/tomcat/webapps/ROOT; # Update path! proxy_cache_path /var/cache/nginx keys_zone=dhis:250m inactive=1d; + gzip on;