Changes
Jump to navigation
Jump to search
Working with PostgreSQL (view source)
Revision as of 16:01, 22 February 2011
, 16:01, 22 February 2011no edit summary
shared_buffers = 512MB #Use about 10-15% of available RAM, to a max of 512Mb on windows
effective_cache_size = 3GB #Use half to 3/4 of available RAM, depending on your pref
work_mem = 32MB 128MB # This is the memory allocated to each query sort (each query may do many)
maintenance_work_mem = 256MB #This is for vacuum, and a max of 256 is recommended.
Note that with ''work_mem'' this is the allocation to each sort. Each query you run may do many sorts and you may have many users, so this can explode quickly. 128Mb is an aggresive setting that assumes only a single user. See the [http://wiki.postgresql.org/wiki/Performance_Optimization various documentation resources], especially the [http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server official performance optimization page] for more information.
Restart the server (on windows use the 'services' control panel) for many changes to take effect:
