max_stack_depth = 7MB
dynamic_shared_memory_type = posix

jit = on
jit_above_cost = '1e300'

enable_partitionwise_aggregate = off
enable_partitionwise_join = off

parallel_leader_participation = off

enable_parallel_append = off

enable_material = off

default_statistics_target = 2500

synchronous_commit = off

logging_collector = on
log_min_messages = WARNING
log_checkpoints = off
log_lock_waits = off

autovacuum_vacuum_scale_factor = 0.01
autovacuum_vacuum_threshold = 1000
autovacuum_vacuum_insert_threshold = 1000
autovacuum_vacuum_insert_scale_factor = 0.01
autovacuum_analyze_threshold = 50
autovacuum_analyze_scale_factor = 0.005
vacuum_cost_limit = 10000
vacuum_cost_page_hit = 0
idle_in_transaction_session_timeout = 86400000
autovacuum_naptime = 15s
log_autovacuum_min_duration = 100
autovacuum_freeze_max_age = 1000000000
vacuum_freeze_min_age = 5000000
checkpoint_completion_target = 0.9
checkpoint_timeout=1h

wal_level = minimal
max_wal_senders = 0
max_worker_processes = 1024
max_prepared_transactions = 1000
max_connections = 1000
max_parallel_workers = 1000

max_parallel_workers_per_gather  = 52
max_parallel_maintenance_workers = 36

work_mem = 3GB
temp_buffers = 4GB
shared_buffers = 40GB
effective_cache_size = 288GB
maintenance_work_mem = 16GB

min_wal_size = 4GB
max_wal_size = 100GB

parallel_setup_cost = 10000
parallel_tuple_cost = 0.05

full_page_writes = off

random_page_cost = 8
seq_page_cost = 1

