CPU: xeon gold 6354 x2
cpus:72
RAM:512
Raid10:SSD 4TB x4
Raid10:HDD 6TB x4
hypervisor: PROXMOX
VM:
agent: 1
balloon: 0
bios: ovmf
boot: order=scsi0;ide2;net0
cores: 18
cpu: host
cpuunits: 1000
efidisk0: SSD_DATASTORE:vm-100-disk-0,efitype=4m,pre-enrolled-keys=1,size=4M
ide2: none,media=cdrom
machine: q35
memory: 260096
meta: creation-qemu=9.0.2,ctime=1744397102
net0: virtio=BC:24:11:75:A2:D3,bridge=vmbr0,firewall=1
numa: 1
ostype: l26
scsi0: SSD_DATASTORE:vm-100-disk-1,aio=io_uring,cache=writeback,discard=on,iothread=1
scsihw: virtio-scsi-single
smbios1: uuid=34c96bea-3536-4e67-bfd8-026315bb9726
sockets: 1
vga: std
vmgenid: 4ece6cf7-a0a0-4a2c-bafd-395b13955d73
# Основные настройки подключения
listen_addresses = '*' # слушаем все адреса
port = 5432
max_connections = 100
# Память
shared_buffers = 64GB # 25–40% от RAM (в твоем случае 256ГБ)
work_mem = 512MB # для сортировок/хэшей
maintenance_work_mem = 4GB # для VACUUM, CREATE INDEX и пр.
effective_cache_size = 192GB # 70–80% от RAM
# Параллелизм
max_worker_processes = 18
max_parallel_workers = 18
max_parallel_workers_per_gather = 4
max_parallel_maintenance_workers = 4
effective_io_concurrency = 200
# Журнал WAL
wal_buffers = 64MB
commit_delay = 1000
checkpoint_timeout = 5min
checkpoint_completion_target = 0.9
max_wal_size = 4GB
min_wal_size = 2GB
# Кеш страниц
random_page_cost = 1.1
seq_page_cost = 1.0
# JIT отключён (1С не выигрывает от него)
jit = off
# Планировщик
plan_cache_mode = force_custom_plan
# Автоматическое обслуживание
autovacuum = on
autovacuum_max_workers = 9
autovacuum_naptime = 20s
autovacuum_vacuum_scale_factor = 0.01
autovacuum_analyze_scale_factor = 0.005
autovacuum_vacuum_cost_limit = 900
# Статистика и логирование
logging_collector = on
log_directory = 'log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_line_prefix = '%m [%p] '
log_timezone = 'Etc/UTC'
# Плантюнер и Online Analyze (Postgres Pro)
shared_preload_libraries = 'plantuner,online_analyze'
plantuner.fix_empty_table = on
online_analyze.enable = on
online_analyze.threshold = 50
online_analyze.scale_factor = 0.1
online_analyze.min_interval = 10000
online_analyze.table_type = 'temporary'
# Язык и локаль
datestyle = 'iso, dmy'
timezone = 'Etc/UTC'
client_encoding = UTF8
lc_messages = 'ru_RU.UTF-8'
lc_monetary = 'ru_RU.UTF-8'
lc_numeric = 'ru_RU.UTF-8'
lc_time = 'ru_RU.UTF-8'
# Конфигурация расширений
default_text_search_config = 'pg_catalog.russian'