Advertisement
Guest User

Untitled

a guest
Mar 31st, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. Filesystem Size Used Avail Use% Mounted on
  2. ***
  3. /dev/md121 880G 490G 346G 59% /mydb/1
  4. /dev/md122 880G 613G 223G 74% /mydb/2
  5. /dev/md123 880G 322G 514G 39% /mydb/3
  6. /dev/md124 880G 506G 330G 61% /mydb/4
  7.  
  8. Filesystem Size Used Avail Use% Mounted on
  9. ***
  10. /dev/sdb 880G 613G 223G 74% /mydb/2
  11. /dev/sda 880G 448G 388G 54% /mydb/1
  12. /dev/sdc 880G 322G 513G 39% /mydb/3
  13. /dev/sdd 880G 773G 63G 93% /mydb/4
  14.  
  15. wal_compression = on
  16. autovacuum_naptime = 2s
  17. autovacuum_analyze_scale_factor = 0
  18. autovacuum_vacuum_scale_factor = 0
  19. max_wal_senders = 5
  20. autovacuum_analyze_threshold = 1000
  21. checkpoint_timeout = 40min
  22. temp_buffers = 3000MB
  23. autovacuum_vacuum_threshold = 1000
  24. autovacuum_vacuum_cost_delay = 100ms
  25. wal_keep_segments = 1000
  26. wal_level = hot_standby
  27. autovacuum_vacuum_cost_limit = 5000
  28. autovacuum_max_workers = 6
  29. listen_addresses = '192.168.1.4'
  30. max_wal_size = 100GB
  31. hot_standby = on
  32.  
  33. standby_mode = 'on'
  34. primary_conninfo = 'user=replication password=mysecretpassword host=master.mydomain.local port=5432 sslmode=prefer sslcompression=1 krbsrvname=postgres'
  35.  
  36. wal_compression = on
  37. autovacuum_naptime = 2s
  38. autovacuum_analyze_scale_factor = 0
  39. autovacuum_vacuum_scale_factor = 0
  40. max_wal_senders = 5
  41. autovacuum_analyze_threshold = 1000
  42. checkpoint_timeout = 40min
  43. temp_buffers = 1GB
  44. autovacuum_vacuum_threshold = 1000
  45. autovacuum_vacuum_cost_delay = 100ms
  46. wal_keep_segments = 6000
  47. wal_level = hot_standby
  48. autovacuum_vacuum_cost_limit = 5000
  49. autovacuum_max_workers = 6
  50. listen_addresses = '192.168.1.5'
  51. cpu_index_tuple_cost = '0.0005'
  52. wal_buffers = 16MB
  53. checkpoint_completion_target = '0.9'
  54. random_page_cost = 2
  55. maintenance_work_mem = 32GB
  56. max_wal_size = 60GB
  57. synchronous_commit = false
  58. work_mem = 2GB
  59. cpu_tuple_cost = '0.001'
  60. default_statistics_target = 500
  61. effective_cache_size = 96GB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement