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 | 8 GB RAM | 16 GB RAM | 32 GB RAM | 64 GB RAM | 128 GB RAM |
|---|---|---|---|---|---|
| PGSQL_EFFECTIVE_CACHE_SIZE | 4 GB | 6 GB | 12 GB | 24 GB | 48 GB |
| PGSQL_SHARED_BUFFERS | 1 GB | 2 GB | 4 GB | 8 GB | 8 GB |
| PGSQL_WORK_MEM | 64 MB | 64 MB | 64 MB | 64 MB | 64 MB |
| PGSQL_WAL_BUFFERS | 16 MB | 32 MB | 32 MB | 32 MB | 32 MB |
| PGSQL_MAINTENANCE_WORK_MEM | 256 MB | 615 MB | 615 MB | 615 MB | 615 MB |
| site-options.conf tokens | 8 GB RAM | 16 GB RAM | 32 GB RAM | 64 GB RAM | 128 GB RAM |
|---|---|---|---|---|---|
| PGSQL_EFFECTIVE_CACHE_SIZE | 6 GB | 12 GB | 24 GB | 48 GB | 96 GB |
| PGSQL_SHARED_BUFFERS | 2 GB | 4 GB | 8 GB | 8 GB | 8 GB |
| PGSQL_WORK_MEM | 64 MB | 64 MB | 64 MB | 64 MB | 64 MB |
| PGSQL_WAL_BUFFERS | 16 MB | 32 MB | 32 MB | 32 MB | 32 MB |
| PGSQL_MAINTENANCE_WORK_MEM | 256 MB | 615 MB | 615 MB | 615 MB | 615 MB |