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