Thanks Knut and Brajesh, Lars we are using 12 Core CPu with SSD and having 48GB RAM but using Postgres 9.4.
We will try with Postgres 9.5 now and let you know the results. Do you recommend anything else other than this? Thanks, Neeraj On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring <[email protected]> wrote: > Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so > perhaps you should try upgrading to 9.5 first. > > On Wed, Oct 19, 2016 at 8:58 AM, Lars Helge Øverland <[email protected]> > 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 >> [email protected] >> http://www.dhis2.org <https://www.dhis2.org/> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > Skype: knutstar > http://dhis2.org > -- Thanks, Neeraj Gupta
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
