postgrespro-1c/big.conf.sample

18 lines
356 B
Text

# DB Version: 9.6
# OS Type: linux
# DB Type: oltp
# Total Memory (RAM): 128 GB
# Number of Connections: 1000
max_connections = 1000
shared_buffers = 32GB
effective_cache_size = 96GB
work_mem = 33554kB
maintenance_work_mem = 2GB
min_wal_size = 2GB
max_wal_size = 4GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100