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