Hi Neeraj, not sure about the relevance of this detail: when I upgraded from 9.4 to 9.5 I found out that there was a postgres parameter (wal_buffers) removed from the current DHIS2 implementer's guide (relating to 9.5), which was still in there up to 2.24 (relating to 9.4). Also I had the feeling that during the upgrade process from 9.4 to 9.5 not all my old changes were migrated by the Ubuntu upgrader. So better verify your postgresql.conf with the DHIS guide after upgrading and don't just look for the parameters that are mentioned in the guide, but also check if there are old parameters left from old configurations, that are no longer present in the guide.
Upgrading reduced our time for aggregates by a third, but increased the time for posting dataValues via api. Not yet sure about the reasons as I did an upgrade from Ubuntu 14.4 to 16.4, PostgreSQL 9.4 to 9.5 and DHIS2.22 to DHIS2.24 at the same time. Maybe you also want to consider reading through a thread from last week: https://lists.launchpad.net/dhis2-users/msg11529.html Regards, Uwe > Neeraj Gupta <neeraj.h...@gmail.com> hat am 19. Oktober 2016 um 10:35 > geschrieben: > > > 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 <knu...@gmail.com> 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 <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/> > >> > >> > >> _______________________________________________ > >> Mailing list: https://launchpad.net/~dhis2-users > >> Post to : dhis2-us...@lists.launchpad.net > >> 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-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
