Database configuration options

Database configuration options

To improve performance of the SurrogateToolsDB, some PostgreSQL options can be changed in order to make use of more memory on the system. The options listed below are found in the postgres.conf configuration file. The specific location of this file can vary depending on your Linux flavor and PostgreSQL version, but the config file is often in /var/lib/pgsql/ or /etc/postgresql/.

For more details on the settings, see the PostgreSQL Resource Consumption documentation for your version of PostgreSQL.

After changing the postgres.conf config file, you'll need to restart the PostgreSQL service for the new config settings to take effect.

In postgres.conf, look for the RESOURCE USAGE section.

#------------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------

# - Memory -

shared_buffers = 1280MB                 # min 128kB
...
work_mem = 24MB                         # min 64kB
maintenance_work_mem = 256MB            # min 1MB