try this for index repair (after doing a backup): https://www.postgresql.org/docs/9.5/static/sql-reindex.html
Regards, Uwe > Abdul karim Jaafar <[email protected]> hat am 12. Oktober 2016 um > 16:28 geschrieben: > > > Dears Uwe and knut, > > > > - I actually tried new build for DHIS2 2.22 also I tried upgrading to > 2.23 and 2.24 without any change in analytics period, in Catalina.out there is > no error in analytics period, but the first step that according to > ”organisationunit structure” takes too much time than the other steps also it > create a lot of analytic tables like “analytics_event_2061_weonplpea8a” with > no data and expectable year “2061, 2006,2018,2010,2017” > > > > - What do you mean by: “rebuild/repair all the indexes in my > installation”, how can I do maintains to database > > > > I thing the problem came from categoryoptioncombo when I’ve compared between > these tables: _categoryoptioncomboname, categoryoptioncombo and > > Categoryombos_optioncombos I found about two hundred thousand > categoryoptioncomboid that not exist in table and not exist in others, also I > noticed that analytic period increase when I add new category options to > attribute categories. > > > > Any idea? > > > > From: Knut Staring [mailto:[email protected]] > Sent: Wednesday, October 12, 2016 3:35 PM > To: Uwe Wahser <[email protected]> > Cc: Abdul karim Jaafar <[email protected]>; > [email protected] > Subject: Re: [Dhis2-users] long period of analytics > > > > Maybe also test an upgrade? > > > > On 12 Oct 2016 14:22, "Uwe Wahser" <[email protected] <mailto:[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] > > <mailto:[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] > > <mailto:[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] > <mailto:[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
