Home » Database Optimization

DB Optimization

This document explains about optimizing the RAM memory consumption for PostgreSQL database. This is applicable only for customers running Desktop Central on PGSQL database. Performance of PGSQL database, is mainly  determined by the amount of RAM memory consumed. Desktop Central requires a minimum of 4GB as the default RAM memory. If you have surplus RAM memory, then you can choose to customize the RAM memory consumption. Increasing the memory consumption, will allow the back end operations to be performed faster, this will impact other services/applications running on the same computer. Assume, you have 12GB as RAM memory and Desktop Central uses only 4GB by default. You can customize this settings on the Desktop Central server. You can increase the memory consumption upto 80%, which means you can increase the RAM memory consumption limit upto 9.6GB in this case. Increasing the RAM memory consumption to 80% does not mean, that the RAM memory will not be shared for any other operation. The consumption will be determined only based on the operations performed on the Desktop Central server. If the back end operations running in the server does not consume the specified memory, it can be utilized by other applications.

You can customize the memory consumption settings by clicking Admin tab, and choosing DB Optimization under Database Settings.