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
