44 lines
1.1 KiB
Text
44 lines
1.1 KiB
Text
# Generated by PGConfig 3.1.0 (1d600ea0d1d79f13dd7ed686f9e2befc1fcf9226)
|
|
# https://api.pgconfig.org/v1/tuning/get-config?format=conf&include_pgbadger=true&log_format=csvlog&max_connections=200&pg_version=15&environment_name=WEB&total_ram=4GB&cpus=4&drive_type=SSD&arch=x86-64&os_type=linux
|
|
|
|
# Memory Configuration
|
|
shared_buffers = 1GB
|
|
effective_cache_size = 3GB
|
|
work_mem = 5MB
|
|
maintenance_work_mem = 205MB
|
|
|
|
# Checkpoint Related Configuration
|
|
min_wal_size = 2GB
|
|
max_wal_size = 3GB
|
|
checkpoint_completion_target = 0.9
|
|
wal_buffers = -1
|
|
|
|
# Network Related Configuration
|
|
listen_addresses = '*'
|
|
max_connections = 200
|
|
|
|
# Storage Configuration
|
|
random_page_cost = 1.1
|
|
effective_io_concurrency = 200
|
|
|
|
# Worker Processes Configuration
|
|
max_worker_processes = 8
|
|
max_parallel_workers_per_gather = 2
|
|
max_parallel_workers = 2
|
|
|
|
# Logging configuration for pgbadger
|
|
logging_collector = on
|
|
log_checkpoints = on
|
|
log_connections = on
|
|
log_disconnections = on
|
|
log_lock_waits = on
|
|
log_temp_files = 0
|
|
lc_messages = 'C'
|
|
|
|
# Adjust the minimum time to collect the data
|
|
log_min_duration_statement = '10s'
|
|
log_autovacuum_min_duration = 0
|
|
|
|
# CSV Configuration
|
|
log_destination = 'csvlog'
|
|
|