db1.conf

# What IPs to listen on.
listen_addresses = '192.168.1.73,172.16.0.122'

# Logging setup.
log_destination = 'syslog'
syslog_facility = 'LOCAL4'
syslog_ident = 'postgres'
log_min_duration_statement = 1000
log_line_prefix = '%t [%p-%l] %q%u@%d '

# Optimizations
huge_pages = on
constraint_exclusion = on
effective_cache_size = 576GB
work_mem = 256MB
maintenance_work_mem = 1536MB
shared_buffers = 188GB
random_page_cost = 1.5
max_connections = 2000
join_collapse_limit = 9

#wal settings
wal_level = hot_standby
wal_buffers = 8MB
max_wal_size = 3072MB
checkpoint_timeout = 30min
checkpoint_completion_target = 0.9
archive_mode = on
archive_command = 'cp %p /usr/backups/database2/wal/%f'
#archive_command = '/bin/true'
max_wal_senders = 5
hot_standby = on
hot_standby_feedback = on