What are the right PostgreSQL settings for my site?

Your site's PostgreSQL settings depend on the conditions your site is operating under, especially the number and size of projects and the number of users.

The default values in the site-options.conf file are designed for a TeamForge site running on a system with 8 GB of RAM. This table contains recommended values for systems with various amounts of RAM, based on testing carried out in CollabNet's performance lab. Use your discretion in selecting the right values for your environment.

Note: Remember to recreate the runtime environment after changing any value in the site-options.conf file.

Recommended values if PostgreSQL and TeamForge are on the same server

site-options.conf tokens 8GB RAM 16GB RAM 32GB RAM 64GB RAM 128GB RAM
PGSQL_EFFECTIVE_CACHE_SIZE= 4GB 6GB 12GB 24GB 48GB
PGSQL_SHARED_BUFFERS= 1GB 2GB 4GB 8GB 8GB
PGSQL_WORK_MEM= 64MB 64MB 64MB 64MB 64MB
PGSQL_WAL_BUFFERS= 16MB 32MB 32MB 32MB 32MB
PGSQL_MAINTENANCE_WORK_MEM= 256MB 615MB 615MB 615MB 615MB

Recommended values if PostgreSQL is on a separate server

site-options.conf tokens 8GB RAM 16GB RAM 32GB RAM 64GB RAM 128GB RAM
PGSQL_EFFECTIVE_CACHE_SIZE= 6GB 12GB 24GB 48GB 96GB
PGSQL_SHARED_BUFFERS= 2GB 4GB 8GB 8GB 8GB
PGSQL_WORK_MEM= 64 MB 64MB 64MB 64MB 64MB
PGSQL_WAL_BUFFERS= 16 MB 32MB 32MB 32MB 32MB
PGSQL_MAINTENANCE_WORK_MEM= 256MB 615MB 615MB 615MB 615MB