dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

The most important setting to take immediate use of the RAM is shared_buffers.

What OS are you running and what else is running on the machine?  Are
you also running 1 or 2 or 3 dhis2 instances?  How "busy" are these in
terms of number of users?  If the server is just a database server
then you can optimize it more aggressively for that but if you are
also running tomcat and possibly some other things then you need to
strike some balance.

Can you share your postgresql.conf file?  It might be you are not
getting the most out of your existing 12G.

Final thought - did you check how many of those datavalues are
actually zeroes?  Sometimes (eg when systems start storing 80% zeroes)
it is an indication you need to maybe think differently about whether
to actually store these or not.

On 15 May 2015 at 08:22, Morina Matasi <morena.motsieng@xxxxxxxxx> wrote:
> How many records can be in the DataValue table without losing efficiency on
> a server with 12GB of memory. My DataValue table now has almost 10 million
> records. I have 12GB of RAM. Queries are taking long to execute. If I
> increase my RAM to 24GB, what settings should I change to optimise my
> server??
>
> _______________________________________________
> 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
>