Just to reply for completeness.
MWM was high enough (4GB) .
Apparently we were having max_worker_processes = 18 and 16 subscriptions
running, leaving no room for additional processes. What an oversight.
Once mwp was bumped (to 42 on 64 core machine), everything started working
as expected.
On Sat
On Fri, Apr 24, 2020 at 7:32 AM Radoslav Nedyalkov wrote:
> We 're rebuilding a big table which has set parallel_workers = 6
> system has
> max_parallel_maintenance_workers | 6 |
> /var/lib/pgsql/11/data/postgresql.sumup.conf
> max_parallel_workers | 16 |
> /var/lib/pgsq
Hello everybody,
We 're rebuilding a big table which has set parallel_workers = 6
system has
max_parallel_maintenance_workers | 6 |
/var/lib/pgsql/11/data/postgresql.sumup.conf
max_parallel_workers | 16 |
/var/lib/pgsql/11/data/postgresql.sumup.conf
max_parallel_workers_p
