DavidGoussev/postgres_config.md

Forked from rgreenjr/postgres_config.md

Created April 4, 2017 23:25

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/DavidGoussev/8e614ceb25de53b1d675220de206ac8b.js"></script>
Save DavidGoussev/8e614ceb25de53b1d675220de206ac8b to your computer and use it in GitHub Desktop.

PostgreSQL Configuration Optimization

Raw

PostgreSQL Configuration Optimization

Only four values really matter:

shared-buffers: below 2GB: set it to 20% of full memory; below 32GB: 25% of your full memory.
work_mem: Start low at 32/64MB. Look for temporary file lines in logs. Then set it to 2-3x the largest temp file that you see. This setting can give a huge speed boost (if set properly).
maintenance_work_mem: Set it to 10% of system memory.
effective_cache_size: Only a hint to postgres. Just set it to the amount of filesystem cache available.