Changes
Jump to navigation
Jump to search
Then restart 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:
Working with PostgreSQL (view source)
Revision as of 15:53, 22 February 2011
, 15:53, 22 February 2011no edit summary
You will almost surely want to 'performance tune' your postgresql database, as the default settings are near useless. In particular edit postgresql.conf (which is in the data directory of your install) to change:
shared_buffers = 512MB #Use about 10-15% of available RAM , to a max of 512Mb on windows effective_cache_size = 2GB 3GB #Use a large chunk half to 3/4 of available RAM, depending on your pref work_mem = 32MB # 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.
pg_ctl restart
