Skip to content

Instantly share code, notes, and snippets.

@ahmadsoe

ahmadsoe/posgresql-tuning

Created May 6, 2014 10:30
Show Gist options
  • Save ahmadsoe/12aec2e63bbb0e32c6bd to your computer and use it in GitHub Desktop.
Save ahmadsoe/12aec2e63bbb0e32c6bd to your computer and use it in GitHub Desktop.
Download ZIP
Posgresql 9.3 Tuning
Raw
posgresql-tuning
## Posgresql 9.3 Tuning
# RAM = 8GB
# http://pgtune.leopard.in.ua/
max_connections = 200
shared_buffers = 2GB
effective_cache_size = 6GB
work_mem = 10485kB
maintenance_work_mem = 512MB
checkpoint_segments = 32
checkpoint_completion_target = 0.7
wal_buffers = 16MB
default_statistics_target = 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment