Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # I'm trying Blake's settings for our production DB
- default_statistics_target = 200 # Bmagic 2022-10
- maintenance_work_mem = 1GB # Bmagic 2022-10
- constraint_exclusion = on # Bmagic 2022-10
- checkpoint_completion_target = 0.9 # Bmagic 2022-10
- effective_cache_size = 500GB # Bmagic 2022-10
- work_mem = 512MB # Bmagic 2022-10
- wal_buffers = 8MB # Bmagic 2022-10
- shared_buffers = 32GB # Bmagic 2022-10
- max_connections = 800 # Bmagic 2022-10
- random_page_cost = 1.0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement