dhis2-devs team mailing list archive

[Neeraj Gupta <neeraj.hisp@xxxxxxxxx>]

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 <lars@xxxxxxxxx>
wrote:

>
> 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 <https://www.postgresql.org/docs/9.6/static/release-9-6.html>
> than 9.5)
> - tuning
> <https://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_postgresql_performance_tuning>
> of postgresql
>
>
> regards,
>
> Lars
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>


-- 
Thanks,
Neeraj Gupta