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.
| 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 |
| 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= | 64MB | 64MB | 64MB | 64MB | 64MB |
| PGSQL_WAL_BUFFERS= | 16MB | 32MB | 32MB | 32MB | 32MB |
| PGSQL_MAINTENANCE_WORK_MEM= | 256MB | 615MB | 615MB | 615MB | 615MB |