dhis2-devs team mailing list archive

["Dr. Sunil Gavaskar ParthaSarathy" <sunilgavaskar@xxxxxxxxxxxxxx>]

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 ParthaSarathy. M.B., B.S., D.A.,
Medical Officer
Tamil Nadu Health Systems Project

Sent from my iPhone

> On 19-Oct-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 than 9.5)
> - tuning of postgresql
> 
> 
> regards,
> 
> Lars
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> lars@xxxxxxxxx
> http://www.dhis2.org
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp