gistfile1.txt

--- config for def

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='replica'                     # 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 = 80GB
maintenance_work_mem = 16GB            # be nice to pgvector
bgwriter_lru_maxpages = 2000           # max buffers written/round, 0 disables
bgwriter_delay = 50ms                  # 10-10000ms between rounds
wal_compression = off
max_wal_size = 96GB
min_wal_size = 48GB
log_autovacuum_min_duration=0
log_checkpoints = on

checkpoint_timeout=1800s
checkpoint_completion_target=0.9
autovacuum_max_workers=8
autovacuum_naptime=10s
# x9a2a
#autovacuum_vacuum_cost_delay=2ms
autovacuum_vacuum_cost_delay=1ms
autovacuum_vacuum_cost_limit=4000
autovacuum_vacuum_scale_factor=0.05
autovacuum_vacuum_insert_scale_factor=0.05
autovacuum_work_mem=1024MB

vacuum_buffer_usage_limit=256MB

jit = off

--- config for wm8 

diff $(config above from "def") $( config for "wm8")

> work_mem=8MB
> maintenance_work_mem=1GB

--- config for pq4

diff $(config above from "def") $( config for "pq4")

< max_parallel_workers_per_gather = 0   # taken from max_parallel_workers
< max_parallel_workers = 0              # maximum number of max_worker_processes that

> work_mem=8MB
> maintenance_work_mem=1GB
> max_parallel_workers_per_gather = 2     # taken from max_parallel_workers
> max_parallel_workers = 8                # maximum number of max_worker_processes that
> max_parallel_maintenance_workers = 4

-- the wm8 config adds ...

work_mem=8MB
maintenance_work_mem=1GB

-- the pq4 config