=== modified file 'src/docbkx/en/dhis2_implementation_guide_installation.xml' --- src/docbkx/en/dhis2_implementation_guide_installation.xml 2012-09-07 02:48:46 +0000 +++ src/docbkx/en/dhis2_implementation_guide_installation.xml 2012-09-30 20:39:51 +0000 @@ -45,7 +45,11 @@ and set the following properties: shared_buffers = 512MB Determines how much memory PostgreSQL can use for caching of query data. Is set too low by default since it depends on kernel shared memory which is low on some operating systems. - effective_cache_size = 3500MB + work_mem = 12MB + Determines the amount of memory used for internal sort and hash operations. + maintenance_work_mem = 128MB + 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 performance of index creation during the data mart process. + effective_cache_size = 3300MB An estimate of how much memory is available for caching (not an allocation) and is used by PostgreSQL to determine whether a query plan will fit into memory or not (setting it too high might result in unpredictable and slow behavior). checkpoint_segments = 32 PostgreSQL writes new transactions to a log file called WAL segments which are 16MB in size. When a number of segments have been written a checkpoint occurs. Setting this number to a larger value will thus improve performance for write-heavy systems such as DHIS 2.