Re: parallel index creation: maintenance_work_mem not honored?

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: parallel index creation: maintenance_work_mem not honored?
Date: 2022-06-20 14:47:21
Message-ID: CAH2-Wz=s47yo-gi5tdE1xneEB9nkBU4stzJMMiJ-Ny5qibkfzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jun 20, 2022 at 2:42 AM Fabio Pardi <f(dot)pardi(at)portavita(dot)eu> wrote:
> Is this behavior expected? I cannot find mentions on the documentation nor on the literature available to me.

Yes, this is expected. Parallel CREATE INDEX performs its parallel
sort by having workers generate sorted runs, which are written to temp
files, and then having the leader process merge the sorted runs
together as the index is built.

In the case where there is amble maintenance_work_mem, all writes to
and reads from temp files will be sequential.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2022-06-20 17:49:43 Re: postrgesql query planner wrong desicion
Previous Message Fabio Pardi 2022-06-20 09:42:44 parallel index creation: maintenance_work_mem not honored?