# PGTune: 64GB RAM / 32 cores / NVMe — Web/Mixed workload
max_connections = 100
shared_buffers = 16GB
huge_pages = try
effective_cache_size = 48GB
work_mem = 256MB
hash_mem_multiplier = 2.0
maintenance_work_mem = 2GB
autovacuum_work_mem = 1GB
wal_buffers = 64MB
max_wal_size = 4GB
min_wal_size = 1GB
checkpoint_timeout = 15min
checkpoint_completion_target = 0.9
wal_compression = zstd
random_page_cost = 1.1
effective_io_concurrency = 200
parallel_setup_cost = 100
parallel_tuple_cost = 0.01
max_worker_processes = 32
max_parallel_workers = 16
max_parallel_workers_per_gather = 8
max_parallel_maintenance_workers = 8
default_statistics_target = 100