Thanks Lars, we will give this a try and let you know. How much time do you expect to run for 100 GB database in ideal conditions?
Thanks, Neeraj On Wed, Oct 19, 2016 at 12:28 PM, Lars Helge Øverland <l...@dhis2.org> wrote: > > Hi Neeraj, > > what usually helps to improve runtime is to improve/increase: > > - ssd (read and write speed) > - number of CPUs > - using latest postgresql (9.6 claims to have even better indexing > performance <https://www.postgresql.org/docs/9.6/static/release-9-6.html> > than 9.5) > - tuning > <https://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_postgresql_performance_tuning> > of postgresql > > > regards, > > Lars > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > -- Thanks, Neeraj Gupta
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
