data_directory = '/ssd/postgresql/11/main'
listen_addresses = '*'
port = 5432
max_connections = 300

shared_buffers = 32200MB
effective_cache_size = 96601MB
maintenance_work_mem = 2GB
work_mem = 128MB

timescaledb.max_background_workers = 8
max_worker_processes = 43
max_parallel_workers_per_gather = 16
max_parallel_workers = 32


wal_buffers = 16MB
min_wal_size = 4GB
max_wal_size = 8GB

default_statistics_target = 500
random_page_cost = 1.0

cpu_tuple_cost = 0.001
cpu_index_tuple_cost = 0.0005

checkpoint_completion_target = 0.9
max_locks_per_transaction = 512
effective_io_concurrency = 200

huge_pages = off
max_stack_depth = 4MB
shared_preload_libraries = 'pg_stat_statements, timescaledb'
bgwriter_delay = 10000ms
bgwriter_lru_maxpages = 1000
bgwriter_lru_multiplier = 10.0
wal_level = hot_standby
wal_compression = on
checkpoint_timeout = 1h
archive_mode = on
archive_command = '/var/lib/postgresql/archive_wal.sh %p %f'
max_wal_senders = 2
max_replication_slots = 2
hot_standby = on
log_min_duration_statement = 3000
log_timezone = 'Europe/Moscow'
autovacuum = on
log_autovacuum_min_duration = 30000
autovacuum_max_workers = 10
autovacuum_vacuum_threshold = 1000
autovacuum_analyze_threshold = 100
autovacuum_vacuum_scale_factor = 0.02
autovacuum_analyze_scale_factor = 0.05
autovacuum_freeze_max_age = 1000000000
autovacuum_multixact_freeze_max_age = 1200000000
autovacuum_vacuum_cost_delay = 5ms
vacuum_freeze_min_age = 250000000
vacuum_freeze_table_age = 750000000
vacuum_multixact_freeze_min_age = 25000000
vacuum_multixact_freeze_table_age = 750000000
timezone = 'Europe/Moscow'
lc_messages = 'en_US.UTF-8'

log_temp_files = 0