Optimizing the performance of the database is the first step to enhance the work of uplook Server – and, consequently, to carry out every operation more efficiently.
- Stop uplook Server services
- Stop PostgreSQL Server Services
- Create a copy of postgresql.conf file
- Edit the original postgresql.conf file (e.g. in Notepad) by changing the parameters below:
shared_buffers = 25 % of accessible RAM (MB) effective_cache_size = 50 % of accessible RAM (MB) wal_buffers = 16MB checkpoint_completion_target=0.9