← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] PostgreSQL-10 Optimization for DHIS2

 

Gerald,

Please post your postgresql.conf file

Regards
Calle

On Sun, 7 Oct 2018 at 23:19, gerald thomas <gerald17006@xxxxxxxxx> wrote:

> Dear All,
> My instance is running on Ubuntu 18.04 with PostgreSQL-10 and i am using
> version 2.27 Build revision 49b827a with an allocated RAM of 16Gb for
> PostgreSQL and 12Gb RAM for the other application processes.
> Whatever i had done during optimization of Postgres had not reduce my
> analytics time below 1 hour. Please can anyone help because i actually want
> analytics to run below 30 minutes.
>
> --
> Regards,
>
> Gerald
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

Follow ups

References