Advertisement
vheathen

postgresql.conf changes only

Aug 18th, 2019
518
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. listen_addresses = '*'
  2. max_connections = 50            # (change requires restart)
  3. shared_buffers = 9GB            # min 128kB
  4. huge_pages = on         # on, off, or try
  5. temp_buffers = 256MB            # min 800kB
  6. work_mem = 128MB                # min 64kB
  7. maintenance_work_mem = 256MB        # min 1MB
  8. dynamic_shared_memory_type = posix  # the default is the first option
  9. max_files_per_process = 10000       # min 25
  10. effective_io_concurrency = 8        # 1-1000; 0 disables prefetching
  11. max_worker_processes = 26       # (change requires restart)
  12. max_parallel_workers_per_gather = 13    # taken from max_parallel_workers
  13. max_parallel_workers = 26       # maximum number of max_worker_processes that
  14. synchronous_commit = off        # synchronization level;
  15. wal_sync_method = fdatasync     # the default is the first option
  16. wal_compression = on            # enable compression of full-page writes
  17. wal_buffers = 16MB          # min 32kB, -1 sets based on shared_buffers
  18. commit_delay = 1000         # range 0-100000, in microseconds
  19. checkpoint_timeout = 30min      # range 30s-1d
  20. max_wal_size = 4GB
  21. min_wal_size = 2GB
  22. checkpoint_completion_target = 0.9  # checkpoint target duration, 0.0 - 1.0
  23. enable_nestloop = off
  24. seq_page_cost = 0.1         # measured on an arbitrary scale
  25. random_page_cost = 0.4          # same scale as above
  26. cpu_operator_cost = 0.00025     # same scale as above
  27. effective_cache_size = 16GB
  28. default_statistics_target = 10000       # range 1-10000
  29. from_collapse_limit = 8
  30. join_collapse_limit = 8     # 1 disables collapsing of explicit
  31. logging_collector = on      # Enable capturing of stderr and csvlog
  32. log_directory = 'pg_log'            # directory where log files are written,
  33. log_min_duration_statement = 50 # -1 is disabled, 0 logs all statements
  34. log_checkpoints = on
  35. log_lock_waits = on         # log lock waits >= deadlock_timeout
  36. log_temp_files = 0          # log temporary files equal or larger
  37. log_timezone = 'W-SU'
  38. stats_temp_directory = '/mnt/ramfs'
  39. log_autovacuum_min_duration = 1000  # -1 disables, 0 logs all actions and
  40. temp_tablespaces = 'ram'            # a list of tablespace names, '' uses
  41. datestyle = 'iso, dmy'
  42. timezone = 'W-SU'
  43. lc_messages = 'ru_RU.UTF-8'         # locale for system error message
  44. lc_monetary = 'ru_RU.UTF-8'         # locale for monetary formatting
  45. lc_numeric = 'ru_RU.UTF-8'          # locale for number formatting
  46. lc_time = 'ru_RU.UTF-8'             # locale for time formatting
  47. default_text_search_config = 'pg_catalog.russian'
  48. max_locks_per_transaction = 640     # min 10
  49. shared_preload_libraries = 'online_analyze, plantuner'          # (change requires restart)
  50. online_analyze.enable = on              # online analize enabled
  51. online_analyze.table_type = 'temporary'
  52. online_analyze.threshold = 50
  53. online_analyze.scale_factor = 0.1
  54. online_analyze.min_interval = 10000
  55. online_analyze.local_tracking = off
  56. online_analyze.verbose = 'off'
  57. plantuner.fix_empty_table = 'on'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement