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.

	8GB RAM	16GB RAM	32GB RAM	64GB RAM	128GB RAM
PGSQL_COMMIT_DELAY	250	250	250	250	250
PGSQL_COMMIT_SIBLINGS	10	10	10	10	10
PGSQL_EFFECTIVE_CACHE_SIZE	512MB	1GB	2GB	4GB	8GB
PGSQL_MAINTENANCE_WORK_MEM	256MB	256MB	256MB	256MB	256MB
PGSQL_MAX_FSM_PAGES	500000	500000	500000	500000	500000
PGSQL_MAX_FSM_RELATIONS	500	500	500	500	500
PGSQL_SHARED_BUFFERS	240MB	480MB	960MB	1.5GB	3.5GB
PGSQL_WORK_MEM	64MB	128MB	256MB	512MB	512MB
PGSQL_VACUUM_COST_DELAY	50	50	50	50	50
PGSQL_WAL_BUFFERS	10MB	10MB	10MB	10MB	10MB