=== 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;