Maybe also test an upgrade? On 12 Oct 2016 14:22, "Uwe Wahser" <[email protected]> wrote:
> Hi Abdul, > > I saw that you posted this already a few months ago - without success, as > it > seems. So let me just take a lucky guess, of what else you could try > (that's > what I'd try): > > - in catalina.out, can you identify a specific phase of the analytics run > where > most of the time is spent or is everything taking longer. Maybe with that > detail > info the DEV team can help you further. > - can you try to list the available database indexes in your installation > and > compare with a fresh install of DHIS2.22 if any are missing? > - can you try to rebuild/repair all the indexes in your installation (never > tried this in PostgreSQL myself, though) > > Don't know if this makes sense, but better than nothing :-) > > Regards, Uwe > > > > Abdul karim Jaafar <[email protected]> hat am 12. Oktober > 2016 um > > 12:22 geschrieben: > > > > > > Dears all, > > > > > > > > I’ve been facing a problem with analytic period for over than two months, > > > > > > > > And I didn’t find any solution for this problem. > > > > > > > > I did a tuning for Postgres and every week I did maintains from data > > administration, also there is no problems in data integrity. > > > > > > > > But the analytic period is increasing gradually for over than 20 hours > > > > > > > > I don’t know what are thing that increase the period for analytics table > > update. > > > > > > > > we have: > > > > Tracked entity instance: 97358 > > > > Tracked entity data value: 1872790 > > > > Tracked entity attribute data value: 1217314 > > > > Data value: 614956 > > > > > > > > Also I have these rows in table below: > > > > _Categoryoptioncomboname: 437689 rows > > > > Categoryombos_optioncombos: 669471 rows > > > > > > > > We did hosting in our own server kindly look for information below: > > > > DHIS2, Database and hosting information: > > > > Version: 2.22 > > > > Build revision: 22090 > > > > Environment variable:DHIS2_HOME > > > > External configuration directory:/home/dhis/config > > > > File store provider: filesystem > > > > Database type: PostgreSQL > > > > Database name: dhis2 > > > > Database user: dhis > > > > Java opts: -Xmx16000m -Xms8000m > > > > Java home: /usr/lib/jvm/java-8-oracle/jre > > > > Java temporary directory: /home/dhis/tomcat-dhis/temp > > > > Java version: 1.8.0_101 > > > > Java vendor: Oracle Corporation > > > > OS name: Linux > > > > OS architecture: amd64 > > > > OS version: 4.4.0-34-generic > > > > Server memory: Mem Total in JVM: 10237 Free in JVM: 8507 Max Limit: 14222 > > > > CPU cores:12 > > > > Users information: > > > > There are: 63 users > > > > User role: 13 > > > > > > > > I think this volume data not too much to effects the analytics. > > > > > > > > Any solutions please? > > > > > > > > > > > > Best regards, > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~dhis2-users > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~dhis2-users > > More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
