64 подписчика

postgresql.auto.conf

# Do not edit this file manually!

# It will be overwritten by the ALTER SYSTEM command.

track_io_timing = 'on'

listen_addresses = '0.0.0.0'

logging_collector = 'on'

log_directory = '/log/pg_log'

log_destination = 'stderr'

log_rotation_size = '0'

log_rotation_age = '1d'

log_filename = '2sdba-s-tpg12.postgresql-%u.log'

log_line_prefix = '%m| %d| %a| %u| %h| %p| %e| '

log_truncate_on_rotation = 'on'

log_checkpoints = 'on'

archive_mode = 'on'

archive_command = 'true'

archive_timeout = '30min'

checkpoint_warning = '60'

checkpoint_completion_target = '0.9'

min_wal_size = '2GB'

synchronous_commit = 'on'

wal_compression = 'on'

random_page_cost = '1.1'

effective_io_concurrency = '300'

wal_sender_timeout = '0'

autovacuum_naptime = '1s'

autovacuum_vacuum_scale_factor = '0.01'

autovacuum_analyze_scale_factor = '0.005'

autovacuum_vacuum_cost_delay = '2ms'

autovacuum_max_workers = '4'

autovacuum_work_mem = '256MB'

vacuum_cost_limit = '4000'

bgwriter_delay = '10ms'

bgwriter_lru_multiplier = '4'

bgwriter_lru_maxpages = '400'

max_locks_per_transaction = '256'

max_pred_locks_per_transaction = '256'

temp_buffers = '14MB'

idle_in_transaction_session_timeout = '1h'

statement_timeout = '8h'

pg_stat_statements.track_utility = 'off'

max_parallel_maintenance_workers = '4'

hash_mem_multiplier = '2'

autovacuum_vacuum_insert_scale_factor = '0.01'

shared_preload_libraries = 'pg_stat_statements , pg_wait_sampling'

commit_delay = '1000'

log_autovacuum_min_duration = '0'

wipe_file_on_delete = 'on'

wipe_heaptuple_on_delete = 'on'

wipe_mem_on_free = 'on'

wipe_memctx_on_free = 'on'

wipe_xlog_on_free = 'on'

log_connections = 'on'

log_disconnections = 'on'

pg_stat_statements.track = 'all'

max_connections = '1000'

max_parallel_workers_per_gather = '1'

max_parallel_workers = '16'

max_worker_processes = '16'

effective_cache_size = '6GB'

work_mem = '32MB'

maintenance_work_mem = '512MB'

max_wal_size = '32GB'

checkpoint_timeout = '5min'

shared_buffers = '4GB'

1 минута

Вчера