Re: [Dhis2-users] 25 hours in completing Analytic

Dear Sir, I had issues in connecting to PoastgreSQL 9.6 due to HSBC error has that been resolved now. Please let me know. I believe 9.6 can handle parallel queries & will have better handling of vacuum, which might be usesful for large databases as handled by Neeraj. Dr. Sunil Gavaskar Partha

Re: [Dhis2-users] 25 hours in completing Analytic

Dear Uwe, Thanks for your valuable suggestion, we will try with PostgreSQL 9.5 and let you know the progress. On Wed, Oct 19, 2016 at 2:01 PM, Uwe Wahser wrote: > Hi Neeraj, > > not sure about the relevance of this detail: when I upgraded from 9.4 to > 9.5 I > found out that there was a postg

Re: [Dhis2-users] 25 hours in completing Analytic

Hi Neeraj, not sure about the relevance of this detail: when I upgraded from 9.4 to 9.5 I found out that there was a postgres parameter (wal_buffers) removed from the current DHIS2 implementer's guide (relating to 9.5), which was still in there up to 2.24 (relating to 9.4). Also I had the feeling

Re: [Dhis2-users] 25 hours in completing Analytic

Thanks Knut and Brajesh, Lars we are using 12 Core CPu with SSD and having 48GB RAM but using Postgres 9.4. We will try with Postgres 9.5 now and let you know the results. Do you recommend anything else other than this? Thanks, Neeraj On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring wrote: > Ju

Re: [Dhis2-users] 25 hours in completing Analytic

Hi Neeraj, what usually helps to improve runtime is: - ssd () - number of CPUs - On Wed, Oct 19, 2016 at 7:13 AM, Neeraj Gupta wrote: > Dear team, > > In one of the Indian state we are using DHIS 2.23 and the database size is > going around 100 GB and once we run analytic it reaches to 500

Re: [Dhis2-users] 25 hours in completing Analytic

Thanks Lars, we will give this a try and let you know. How much time do you expect to run for 100 GB database in ideal conditions? Thanks, Neeraj On Wed, Oct 19, 2016 at 12:28 PM, Lars Helge Øverland wrote: > > Hi Neeraj, > > what usually helps to improve runtime is to improve/increase: > > - s

Re: [Dhis2-users] 25 hours in completing Analytic

Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so perhaps you should try upgrading to 9.5 first. On Wed, Oct 19, 2016 at 8:58 AM, Lars Helge Øverland wrote: > > Hi Neeraj, > > what usually helps to improve runtime is to improve/increase: > > - ssd (read and write speed) >

Re: [Dhis2-users] 25 hours in completing Analytic

Hi Neeraj, what usually helps to improve runtime is to improve/increase: - ssd (read and write speed) - number of CPUs - using latest postgresql (9.6 claims to have even better indexing performance than 9.5) - tuning

[Dhis2-users] 25 hours in completing Analytic

Dear team, In one of the Indian state we are using DHIS 2.23 and the database size is going around 100 GB and once we run analytic it reaches to 500 GB and analytic is taking around 25 hours to complete. We are using Postgres 9.4. Has anyone experienced the situation with 100 GB database or more?