Конфигурация СУБД, подготовленная pgpro_tune

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

# The following settings were added by pgpro_tune.

# pgpro_tune was run with the following options:

# -D /data/pg_data

# At 2026-03-14 08:45:28

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

# 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-14 08:45:28

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