66 подписчиков

#Конфигурация PGPRO_TUNE

# 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_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'

pg_stat_statements.track_utility = 'off'

shared_preload_libraries = 'pg_stat_statements , pg_wait_sampling'

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'

# 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'

pg_stat_statements.track_utility = 'off'

shared_preload_libraries = 'pg_stat_statements , pg_wait_sampling'

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'

#------------------------------------------------------------------------------

# The following settings were added by pgpro_tune.

# pgpro_tune was run with the following options:

# -D /data/pg_data

# At 2026-03-07 09:17:50

#------------------------------------------------------------------------------

# Memory configuration

shared_buffers = 1919MB

effective_cache_size = 3838MB

max_connections = 239

work_mem = 32MB

temp_buffers = 16MB

maintenance_work_mem = 479MB

autovacuum_work_mem = 239MB

# Vacuum and bgwriter configuration

autovacuum_max_workers = 4

vacuum_cost_limit = 400

autovacuum_naptime = 20s

autovacuum_analyze_scale_factor = '0.005'

bgwriter_delay = 20ms

bgwriter_lru_multiplier = '4.0'

bgwriter_lru_maxpages = 4000

# Additional configuration

track_activity_query_size = 10kB

default_statistics_target = 800

wal_compression = lz4

default_toast_compression = lz4

log2_num_lock_partitions = 8

log_lock_waits = on

log_connections = on

log_disconnections = on

max_wal_size = 4GB

min_wal_size = 2GB

effective_io_concurrency = 200 # for SSD

#effective_io_concurrency = 500 # for NVMe

#effective_io_concurrency = 1 # for HDD

random_page_cost = '1.1' # for NVMe SSD

#random_page_cost = 1.3 # for SATA SSD

#random_page_cost = 4.0 # for HDD

jit = off

autoprepare_threshold = 2

autoprepare_for_protocol = simple

plan_cache_lru_memsize = 100MB

generic_plan_fuzz_factor = '0.9'

#------------------------------------------------------------------------------

# End of settings added by pgpro_tune at 2026-03-07 09:17:50

#------------------------------------------------------------------------------

2 минуты

9 марта