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.motsi...@gmail.com> 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@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
