Gerald, Please post your postgresql.conf file
Regards Calle On Sun, 7 Oct 2018 at 23:19, gerald thomas <gerald17...@gmail.com> 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@lists.launchpad.net > 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.hedb...@gmail.com Skype: calle_hedberg *******************************************
_______________________________________________ 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