Example of the configuration items modified for a system with 20 cores and 32 GB of memory for PostgreSQL version 12.7:

#------------------------------------------------------------------------------

# pgtune config Based on 32947648 KB RAM, platform Linux

#------------------------------------------------------------------------------

max_connections = 1500

shared_buffers = 8GB

effective_cache_size = 24GB

maintenance_work_mem = 2GB

checkpoint_completion_target = 0.9

wal_buffers = 16MB

default_statistics_target = 100

random_page_cost = 1.1

effective_io_concurrency = 300

work_mem = 3990kB

min_wal_size = 1GB

max_wal_size = 4GB

max_worker_processes = 20

max_parallel_workers_per_gather = 4

max_parallel_workers = 20

max_parallel_maintenance_workers = 4