← Back to team overview

dhis2-users team mailing list archive

Help configuring Postgres 9.5 and Java Opts for DHIS-2 2.23

 

Hi all,

I have an Intel Core i7 Windows 10 64bit computer with 16 Gig of RAM and
can't seem to configure it to run analytics correctly.

I ran analytics just fine on the same computer with the same DHIS-2
instance using 2.21 and postgres 9.4 - it took just over 1 hour to run.

Now it seems to hang after about 2 hours... no error message.

I've tried the settings recommended in the 2.23 implementation guide but
then I can't even get the instance to run.  I have cut back on the
Java_opts and added the UseCodeCasheFlushing..

-Xmx7000m -Xms3000m -XX:+UseCodeCacheFlushing

My main postgres.conf file settings - somewhat modified from the
recommendations, are below:

# - Memory -

shared_buffers = 1600MB # min 128kB
work_mem = 10MB # min 64kB
maintenance_work_mem = 512MB # min 1MB
maintenance_work_mem
dynamic_shared_memory_type = windows # the default is the first option
#------------------------------------------------------------------------------
# WRITE AHEAD LOG
#------------------------------------------------------------------------------


synchronous_commit = off # synchronization level;
# off, local, remote_write, or on
wal_buffers = 16MB # min 32kB, -1 sets based on shared_buffers
# (change requires restart)
wal_writer_delay = 10000ms # 1-10000 milliseconds



-- 
*Randy Wilson*
*Team Leader: **Knowledge Management, Data Use and Research*
Rwanda Health System Strengthening Activity
Management Sciences for Health
Rwanda-Kigali
Direct: +250 788308835
E-mail: rwilson@xxxxxxx
Skype: wilsonrandy_us
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
www.msh.org

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*