The PGSQL_EFFECTIVE_CACHE_SIZE variable specifies the size of the OS data cache that is available to PostgreSQL. PostgreSQL can use that data to select the optimal way to execute requests.
The right value for this variable depends in part on the available RAM on the server where your site is running. Set this value at the highest amount of RAM that you expect to be always available to PostgreSQL.
CollabNet recommends these settings:
| 8GB RAM | 16GB RAM | 32GB RAM | 64GB RAM | 128GB RAM |
|---|---|---|---|---|
| 512MB | 1GB | 2GB | 4GB | 8GB |
Questions? Comments? Talk to other TeamForge users and CollabNet engineers.
Copyright 2011 CollabNet Corporation | Site Feedback | Terms of Use | Privacy Policy | Copyright and Trademark | Support