Guest User

Untitled

a guest
Jul 17th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. [gray@rxtx-249 tmp]$ sudo cat /var/lib/pgsql/data/postgresql.conf|grep -v -P '^\s*#|^\s*$'| perl -pne 's/\s*#.*$//'
  2. listen_addresses = '*'
  3. max_connections = 300
  4. shared_buffers = 2GB
  5. work_mem = 64MB
  6. maintenance_work_mem = 256MB
  7. shared_preload_libraries = 'auto_explain,pg_stat_statements'
  8. bgwriter_lru_maxpages = 700
  9. synchronous_commit = off
  10. wal_buffers = 8MB
  11. checkpoint_segments = 50
  12. checkpoint_timeout = 10min
  13. checkpoint_completion_target = 0.8
  14. effective_cache_size = 10GB
  15. constraint_exclusion = on
  16. log_destination = 'syslog'
  17. silent_mode = on
  18. log_min_error_statement = warning
  19. log_min_duration_statement = 2000ms
  20. log_checkpoints = on
  21. log_statement = 'none'
  22. track_activity_query_size = 16384
  23. log_autovacuum_min_duration = 0
  24. autovacuum_naptime = 10min
  25. autovacuum_vacuum_threshold = 500
  26. autovacuum_analyze_threshold = 250
  27. autovacuum_vacuum_scale_factor = 0.05
  28. autovacuum_analyze_scale_factor = 0.03
  29. statement_timeout = 35000
  30. datestyle = 'iso, dmy'
  31. timezone = 'Europe/Moscow'
  32. lc_messages = 'en_US.UTF-8'
  33. lc_monetary = 'en_US.UTF-8'
  34. lc_numeric = 'en_US.UTF-8'
  35. lc_time = 'en_US.UTF-8'
  36. default_text_search_config = 'pg_catalog.english'
  37. escape_string_warning = off
  38. custom_variable_classes = 'auto_explain,pg_stat_statements'
  39. auto_explain.log_min_duration = '3s'
  40. pg_stat_statements.max = 10000
  41. pg_stat_statements.track = all
Add Comment
Please, Sign In to add comment