parallel_workers_per_gather必须大于polar_px_dop_per_node?区分功能的参数有三个,px_workers那个应该...
max_parallel_workers_per_gather = 2 max_locks_per_transaction = 384 but we tried with work_mem to 130mb, shared_buffer to a maximum fo 40gb, effective_cache to 4gb shared memory limits are very big: max number of segments = 4096 max seg size (kbytes) = 18014398509465599 max total shar...
#max_parallel_workers_per_gather = 2 # taken from max_parallel_workers #max_parallel_maintenance_workers = 2 # taken from max_parallel_workers #max_parallel_workers = 8 # maximum number of max_worker_processes that # can be used in parallel operations ...