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 <abdulkarim.jaafa...@gmail.com> 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:knu...@gmail.com] 
> Sent: Wednesday, October 12, 2016 3:35 PM
> To: Uwe Wahser <u...@wahser.de>
> Cc: Abdul karim Jaafar <abdulkarim.jaafa...@gmail.com>;
> dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] long period of analytics
> 
>  
> 
> Maybe also test an upgrade? 
> 
>  
> 
> On 12 Oct 2016 14:22, "Uwe Wahser" <u...@wahser.de <mailto:u...@wahser.de> >
> 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 <abdulkarim.jaafa...@gmail.com
> > <mailto:abdulkarim.jaafa...@gmail.com> > 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     : dhis2-users@lists.launchpad.net
> > <mailto:dhis2-users@lists.launchpad.net> 
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@lists.launchpad.net
> <mailto:dhis2-users@lists.launchpad.net> 
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Reply via email to