# provenance 2026-10-11T05:06:28Z
host: ip-172-31-0-126 6.12.111+deb13-cloud-amd64
CPU(s):                                  96
Model name:                              INTEL(R) XEON(R) PLATINUM 8559C
Socket(s):                               1
CPU(s) scaling MHz:                      29%
NUMA node(s):                            1
               total        used        free      shared  buff/cache   available
Mem:             755         210         448           0         101         545
HugePages_Total:   104448
Hugepagesize:       2048 kB
thp: always madvise [never]
governor: performance
storage: md0 20.5T RAID0 of 6 local NVMe, xfs
base c4ba16b8bd2 dev: drop patched glibc, fix pg-test-one/pg-format postgres-sha256=93ed63faacc23d93
p6 69dca9e1b4b Carry index-computed values up through joins and Appends postgres-sha256=d29f71f0fb7c7a52
p7 5ec21b16ca0 Carry index-computed values through outer joins, Gather and  postgres-sha256=13fb366904ead629
drivers: 172.31.7.58 172.31.5.94 172.31.2.62 (c8i.4xlarge, HammerDB 6.0)
--- postgresql.conf (benchmark section)
# --- cf7392 benchmark ---
listen_addresses = '*'
port = 5432
max_connections = 600
shared_buffers = 192GB
huge_pages = on
effective_cache_size = 600GB
work_mem = 64MB
maintenance_work_mem = 8GB
max_wal_size = 200GB
min_wal_size = 32GB
checkpoint_timeout = 30min
checkpoint_completion_target = 0.9
wal_buffers = 256MB
wal_compression = lz4
synchronous_commit = on
fsync = on
full_page_writes = on
random_page_cost = 1.1
effective_io_concurrency = 256
max_worker_processes = 128
max_parallel_workers = 96
max_parallel_workers_per_gather = 8
max_parallel_maintenance_workers = 16
autovacuum_max_workers = 8
autovacuum_vacuum_cost_limit = 4000
jit = off
track_io_timing = on
log_min_messages = warning
log_checkpoints = on
shared_preload_libraries = 'pg_prewarm'
pg_prewarm.autoprewarm = off
