Dear Uwe, Thanks for your valuable suggestion, we will try with PostgreSQL 9.5 and let you know the progress.
On Wed, Oct 19, 2016 at 2:01 PM, Uwe Wahser <u...@wahser.de> wrote: > 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-users@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-users@lists.launchpad.net > > Unsubscribe : https://launchpad.net/~dhis2-users > > More help : https://help.launchpad.net/ListHelp > -- *Thanks & Regards* Arvind rao chikne 9818979986 *Think Green!!!* Please consider your environmental responsibility before printing this e-mail
_______________________________________________ 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
