The ‘max_worker_processes’ parameter determines the maximum number of worker processes you can start. The default value is two, but somewhere around a quarter to a half of your CPU count is a good option. In Timescale, we start at two and progressively increase it as your CPU increases to match half your CPU.
Table of contents
Kickstarting Your PostgreSQL Performance Tuning: max_worker_processesmax_parallel_workersmax_parallel_workers_per_gather`max_parallel_maintenance_workers`autovacuum_max_workersmax_connectionsshared_bufferswork_memmaintenance_work_memmax_locks_per_transactionNote on ERROR: out of shared memoryFine-Tune PostgreSQL Parameters Easily via the Timescale UILet’s Keep Going1 Comment
Sort: