dhis2-users team mailing list archive

[arvind chikne <arvind.chikne@xxxxxxxxx>]

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 <uwe@xxxxxxxxx> 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.hisp@xxxxxxxxx> 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 <knutst@xxxxxxxxx> 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 <lars@xxxxxxxxx>
> > > 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
> > >> lars@xxxxxxxxx
> > >> http://www.dhis2.org <https://www.dhis2.org/>
> > >>
> > >>
> > >> _______________________________________________
> > >> Mailing list: https://launchpad.net/~dhis2-users
> > >> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> > >> 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@xxxxxxxxxxxxxxxxxxx
> > 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