postgresql.conf

# Generated by http://pgconfigurator.cybertec.at

# Connectivity
max_connections = 100
superuser_reserved_connections = 3
 
# Loading libraries and preventing spinlock contentions
shared_preload_libraries = 'pg_stat_statements'
huge_pages = off
 
# Memory Settings
shared_buffers = '256 MB'
work_mem = '32 MB'
maintenance_work_mem = '320 MB'
 
effective_cache_size = '1 GB'
effective_io_concurrency = 100
 
# Background writer
bgwriter_delay = 200ms
bgwriter_lru_maxpages = 100
bgwriter_lru_multiplier = 2.0
bgwriter_flush_after = 0
 
# Replication
wal_level = replica
max_wal_senders = 10
synchronous_commit = on
wal_keep_segments = 130
 
# WAL writing
wal_compression = on
wal_buffers = -1
wal_writer_delay = 200ms
wal_writer_flush_after = 1MB
 
# Checkpointing: 
checkpoint_timeout  = '15 min' 
max_wal_size = '1024 MB'
min_wal_size = '512 MB'
checkpoint_completion_target = 0.9
 
# Parallel queries: 
max_worker_processes = 1
max_parallel_workers_per_gather = 0
max_parallel_workers = 1
 
# General notes: 
# We recommend not to use read-only replicas for scaling
# Note that not all settings are automatically tuned. 
#   Consider contacting experts at 
#   https://www.cybertec-postgresql.com 
#   for more professional expertise.