Postgres Pro
Downloads
Home   >   mailing lists

Re: create index insist on 2 workers only - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: create index insist on 2 workers only
Date
Msg-id CAH2-WznLai5oddawf7tdqGo_5tZa_Z2DPwfsTLCjMgRNmGfDoQ@mail.gmail.com
Whole thread Raw
In response to create index insist on 2 workers only  (Radoslav Nedyalkov <rnedyalkov@gmail.com>)
Responses Re: create index insist on 2 workers only
List pgsql-general
Tree view 
On Fri, Apr 24, 2020 at 7:32 AM Radoslav Nedyalkov <rnedyalkov@gmail.com> 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/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

Try increasing maintenance_work_mem from the default of 64MB. MWM
constrains the number of parallel workers used.

-- 
Peter Geoghegan

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: psql \copy
Next
From: Tom Browder
Date:
Subject: Binary downloads and upgrading the host OS