编辑postgresql. auto. conf启动文件,找到shared_buffer = 2048576的行,并将其更改为128。引导成功!
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 shared memory (kbytes) = 18014398442373116 ...
编辑postgresql. auto. conf启动文件,找到shared_buffer = 2048576的行,并将其更改为128。引导成功!