dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #10504
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.*