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
Gerald,
Please post your postgresql.conf file
Regards
Calle
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@gmail.com
Skype: calle_hedberg
Dear Calle,
Please find the attached requested file.
On Oct 8, 2018, at 6:52 AM, Calle Hedberg <calle.hedberg@gmail.com> wrote:
Gerald,
Please post your postgresql.conf file
Regards
CalleOn Sun, 7 Oct 2018 at 23:19, gerald thomas <gerald17006@gmail.com <mailto:gerald17006@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 <mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp--
******************************************* <>
Calle Hedberg46D 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@gmail.com <mailto:calle.hedberg@gmail.com>
Skype: calle_hedberg*******************************************