create index insist on 2 workers only

From: Radoslav Nedyalkov <rnedyalkov(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: create index insist on 2 workers only
Date: 2020-04-24 14:32:07
Message-ID: CANhtRiYkUTuHXDVGbTaGnVqNHTohqHtj2FMhDeaABT1Sz1Z_jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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_per_gather | 4 |
/var/lib/pgsql/11/data/postgresql.sumup.conf

Also session level on index restore there is
set max_parallel_maintenance_workers = 6;

Still we get only 2 parallel processes in a free of any other load system.
It is postgres 11.7

Where to look at ?

Thank You very much

Rado

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2020-04-24 15:55:34 psql \copy
Previous Message Laurenz Albe 2020-04-24 13:27:12 Re: Weird behaviour of C extension function