# Memory
shared_buffers = '32GB'              # 25% of RAM
work_mem = '512MB'                   # Conservative for multiple concurrent queries
maintenance_work_mem = '4GB'         # Large for vacuum operations
effective_cache_size = '96GB'        # 75% of RAM

# Parallelism
max_parallel_workers = 16            # Half the cores
max_parallel_workers_per_gather = 8  # Quarter the cores

# I/O and WAL
effective_io_concurrency = 200       # High for NVMe
random_page_cost = 1.1               # Low for NVMe
checkpoint_timeout = '30min'
max_wal_size = '16GB'                # Large for busy system