# written by benchmarks/scale/ec2/tune.sh (see its header for the reasoning)
listen_addresses = ''
unix_socket_directories = '/tmp'
max_connections = 300
shared_buffers = 877101MB
huge_pages = on
work_mem = 64MB
maintenance_work_mem = 8GB
effective_cache_size = 942637MB
max_wal_size = 100GB
min_wal_size = 8GB
checkpoint_timeout = 30min
checkpoint_completion_target = 0.9
wal_compression = pglz
wal_buffers = 1GB
synchronous_commit = on
max_worker_processes = 128
max_parallel_workers = 64
max_parallel_workers_per_gather = 8
max_parallel_maintenance_workers = 16
random_page_cost = 1.1
effective_io_concurrency = 256
autovacuum_max_workers = 8
autovacuum_vacuum_cost_limit = 4000
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 10000
track_io_timing = on
log_min_duration_statement = -1
log_checkpoints = on