Hi Neeraj, what usually helps to improve runtime is:
- ssd () - number of CPUs - On Wed, Oct 19, 2016 at 7:13 AM, Neeraj Gupta <[email protected]> wrote: > Dear team, > > In one of the Indian state we are using DHIS 2.23 and the database size is > going around 100 GB and once we run analytic it reaches to 500 GB and > analytic is taking around 25 hours to complete. We are using Postgres 9.4. > > Has anyone experienced the situation with 100 GB database or more? > How did you deal with the time of analytic, Is there any way so that the > time of analytic can be reduced? > > -- > Thanks, > Neeraj Gupta > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland [email protected] http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
