/
conf.diff.cx9a2_bee.90
27 lines (25 loc) · 1.01 KB
/
conf.diff.cx9a2_bee.90
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
#huge_pages = off # on, off, or try
#max_parallel_workers_per_gather = 0 # taken from max_parallel_workers
#max_parallel_workers = 0 # maximum number of max_worker_processes that
checkpoint_warning = 1800s # 0 disables
wal_sync_method = fdatasync # the default is the first option
wal_level='hot_standby' # to log what replication needs
full_page_writes = on # recover from partial page writes
#track_io_timing = on
synchronous_commit = off # synchronization level;
shared_buffers = 10GB
bgwriter_lru_maxpages = 1000 # max buffers written/round, 0 disables
bgwriter_delay = 50ms # 10-10000ms between rounds
#wal_compression = off
#max_wal_size = 40GB
#min_wal_size = 20GB
log_autovacuum_min_duration=0
log_checkpoints = on
checkpoint_timeout=1800s
autovacuum_max_workers=4
autovacuum_naptime=10s
autovacuum_vacuum_cost_delay=2ms
autovacuum_vacuum_cost_limit=4000
autovacuum_vacuum_scale_factor=0.05
#autovacuum_vacuum_insert_scale_factor=0.05
#autovacuum_work_mem=256MB