> /root/bin/PostgreSQL-Tuning.sh
RAM: 1547643 MB

# IST-Werte (ggf. autovacuum_work_mem = maintenance_work_mem):
effective_cache_size		1134 GB
maintenance_work_mem		151 GB
max_connections		150
shared_buffers		378 GB
work_mem		15 GB

# empfohlene Werte, die meistens passen:
autovacuum_work_mem:  151GB (ca. 10% vom RAM)
effective_cache_size: 1134GB (ca. 50-75% vom RAM)
maintenance_work_mem: 151GB (ca. 3-10% vom RAM)
max_connections:      140 (ca. CPU-Kerne + 10%)
shared_buffers:       378GB (ca. 10-25% vom RAM)
work_mem:             15GB (ca. 1% vom RAM; Vorsicht, kann zu OOM-Kill führen!)

#==============================================================================#

{"loop_wait": 10, "maximum_lag_on_failover": 1048576, "postgresql": {"parameters": {"effective_cache_size": "1134GB", "hot_standby": "on", "maintenance_work_mem": "151GB", "max_replication_slots": 10, "max_wal_senders": 10, "shared_buffers": "378GB", "wal_level": "replica", "work_mem": "15GB", "max_connections": "140"}, "use_pg_rewind": true}, "retry_timeout": 10, "ttl": 30}
#==============================================================================#
loop_wait: 10
maximum_lag_on_failover: 1048576
postgresql:
  parameters:
    effective_cache_size: 1134GB
    hot_standby: 'on'
    maintenance_work_mem: 151GB
    max_connections: '140'
    max_replication_slots: 10
    max_wal_senders: 10
    shared_buffers: 378GB
    wal_level: replica
    work_mem: 15GB
  use_pg_rewind: true
retry_timeout: 10
ttl: 30