我的 postgresql 实例不断抛出此错误,在我重新启动数据库后该错误暂时消失。
这是日志:
ERROR: parallel worker failed to initialize
2025-02-25 21:00:51.586 UTC [668] HINT: More details may be available in the server log.
2025-02-25 21:00:51.586 UTC [668] STATEMENT: ...some sql query
2025-02-25 21:00:51.663 UTC [5] LOG: could not fork worker process: Resource temporarily
这是我的配置:
shared_buffers = '8GB'
work_mem = '512MB'
maintenance_work_mem = '2GB'
effective_cache_size = '16GB'
max_parallel_workers_per_gather = 8
max_parallel_workers = 32
autovacuum_work_mem = '1GB'
vacuum_cost_limit = 1000
autovacuum = on
我有 32GB 内存、32vCPU 和 10GB 存储空间。我尝试调整这些设置,但没有效果。我是不是搞错了什么?