The PGSQL_WORK_MEM variable specifies the amount of memory to be used by internal sort operations and hash tables before switching to temporary disk files. .
Integer (in MB)
64MB
The right value for this variable depends in part on the available RAM on the server where your site is running. For optimal performance, consider these settings:
| 8GB RAM | 16GB RAM | 32GB RAM | 64GB RAM | 128GB RAM |
|---|---|---|---|---|
| 64MB | 128MB | 256MB | 512MB | 512MB |
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