Advertisement
Dyrcona

Pg Optimization

Mar 15th, 2024
547
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # I'm trying Blake's settings for our production DB
  2. default_statistics_target = 200 # Bmagic 2022-10
  3. maintenance_work_mem = 1GB # Bmagic 2022-10
  4. constraint_exclusion = on # Bmagic 2022-10
  5. checkpoint_completion_target = 0.9 # Bmagic 2022-10
  6. effective_cache_size = 500GB # Bmagic 2022-10
  7. work_mem = 512MB # Bmagic 2022-10
  8. wal_buffers = 8MB # Bmagic 2022-10
  9. shared_buffers = 32GB # Bmagic 2022-10
  10. max_connections = 800 # Bmagic 2022-10
  11. random_page_cost = 1.0
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement