Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIQr4-000fsl-35 for pgsql-docs@arkaria.postgresql.org; Mon, 10 Nov 2025 12:18:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIQr2-0009IQ-2C for pgsql-docs@arkaria.postgresql.org; Mon, 10 Nov 2025 12:18:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIQe3-000130-0R for pgsql-docs@lists.postgresql.org; Mon, 10 Nov 2025 12:05:13 +0000 Received: from mail-oa1-x36.google.com ([2001:4860:4864:20::36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vIQdz-006N0E-1r for pgsql-docs@lists.postgresql.org; Mon, 10 Nov 2025 12:05:12 +0000 Received: by mail-oa1-x36.google.com with SMTP id 586e51a60fabf-3c9a42d6349so4292360fac.1 for ; Mon, 10 Nov 2025 04:05:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762776310; x=1763381110; darn=lists.postgresql.org; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=urTpzjEFiGgDZexEzs1XT1WC0+FwTix4LogPGGi+X4g=; b=AXVLjgJSaA6BtLnK7vex6hjcPsm1GmnaqjPelMa3/7tXGBcqkEMzAnKEgKnPm6+3rD 0+4aRwT7Zz4zaT+YSr4HtojU9wfkHoxiozXtoHmJf1HiYAfUoXbm8pcpI8xoy7YdepA3 HwhG3pUiJtbxU6M0OXzkhEwJMQx9WDiPa30vTsPps2KOXZ+p3iT78k4T97d4OtVr57Ao bEsFE/NpmsCI9OcQ4hNMCAKO5N5tWRBaPw1PzYuS8u3lq/kZAYjQ4OSxI1y9b1Jwl4ha mzg5uMWBc+bdqgqzds1pIMncBJUWWQPdLoa2+lEVBewjumAbHBlO8HNPOlCx2D4z+Omv q80g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762776310; x=1763381110; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=urTpzjEFiGgDZexEzs1XT1WC0+FwTix4LogPGGi+X4g=; b=OSGfrbFOzBT7gW8sJaOENpr9QUX2MzqWTvWe7T+/gETURnnYaRhCmulPg+j6i8XHUS 41U0/qQCcD6XNccLGdc7Nf+a32a1zSOaHiHkH5wUr3aRA1xfpJDSnEBMF2ON+6/bEuAW FjteeWlaSJjQYsP0+QWd/JnHZDA/Vl9FlXjQ///78tzHr7+Y6oJgl4yJ4FqXufIShJin HJApf/TX6hXbkFIhT972piHyxzi2jx+P/sWRozUi93+NSIhgRksAY8wN2C12VdImMPuY CpJPWQAQ/eTez4tYyuU0IPL7WP/JTnwRcMuH/RTvDThSTYNgZqJETQoogUoJUVLbKQEo DfSA== X-Forwarded-Encrypted: i=1; AJvYcCXCwfq/5Q04DP4D0OTZ6NcyueHzp/Fo7yWKFUc4tbsUe/hKsNRD1OB8BCYzxQ0JQth5qZ5j0VFR20mb@lists.postgresql.org X-Gm-Message-State: AOJu0YxHPN5yij33KiOlRxNdQ9KTt4thempAvczYurDrAqRnR6k0P3hz tMkA4snQtIaLgmz0nzAcB3fO5jOY0dPTlXgKSuxJATNpyL0U45AcEfiNuycm1E96tQ2nZgqD6Ul PUo+KQVJqbPCJ57RttV1iJbN2o1j2HDU= X-Gm-Gg: ASbGncsCoRa9MrTMROM0WBaTSriTrGn1OKUA+88tY5IrwhBf/dIMW5F7yWiFRzNmr7B aecsEfLDS6URaNq2Z1CIR+sdDzWRaFVflFm9QOhI5alwgnqT0VcEaRDN3lz9Yam0DEI0TvlmvZq kJ+ybNtonAXzxUnapf+0wY8IiuqanRZuCrcFnjG0Mg0wKnAJmlNbCkYFyQprOTYgcfTG4HJQBwv Vly/x2jWkSK/c/9Mk99RD+tombq2cWvpN5E6XDiE8ekmfPi93iITtme4o01RHC/anPYh4Gc X-Google-Smtp-Source: AGHT+IGiR4+pCr9YW6z4EnuxGhylkGPTGWJfRRrQMkamnTq5Rea1E3hp5eghTCjJJh6O6iFfd4PCQu1S6TYtcAN6gjo= X-Received: by 2002:a05:6871:20b:b0:3e0:c2b5:df52 with SMTP id 586e51a60fabf-3e7c27d22camr3647760fac.25.1762776310527; Mon, 10 Nov 2025 04:05:10 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:60c5:20b0:605:c9a4:1201 with HTTP; Mon, 10 Nov 2025 04:05:09 -0800 (PST) In-Reply-To: <176273620693.770.1673325455932893600@wrigleys.postgresql.org> References: <176273620693.770.1673325455932893600@wrigleys.postgresql.org> From: "David G. Johnston" Date: Mon, 10 Nov 2025 07:05:09 -0500 X-Gm-Features: AWmQ_bm3-IOStCNoZ5Q2BlM_V2WwYQceHkh3HHR-YX2vHoC0HcqKeHZCy8PHfIo Message-ID: Subject: Re: question about parallel. i read document and i can't solve it. provide the solution please. To: "gyyoono4u@gmail.com" , "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000cebb0106433c5711" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cebb0106433c5711 Content-Type: text/plain; charset="UTF-8" On Sunday, November 9, 2025, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/18/when-can-parallel- > query-be-used.html > Description: > > I'm inquiring because I have some problem getting parallel processing to > run > effectively in PostgreSQL. This is not the right place to seek support. We have a -general mailing list for that. > > How can I increase the Workers Launched value to match the Workers Planned > value, or at least raise it to 4? That level of control is not provided. > > I want to use parallel to speed up for index creation and data insertion > This page clearly states that data writing is not parallelized. David J. --000000000000cebb0106433c5711 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sunday, November 9, 2025, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on th= e website:

Page: https://www.postgresql.org/docs/18/wh= en-can-parallel-query-be-used.html
Description:

I'm inquiring because I have some problem getting parallel processing t= o run
effectively in PostgreSQL.

This is not the = right place to seek support.=C2=A0 We have a -general mailing list for that= .
=C2=A0

How can I increase the Workers Launched value to match the Workers Planned<= br> value, or at least raise it to 4?

That leve= l of control is not provided.
=C2=A0

I want to use parallel to speed up for index creation and data insertion

This page clearly states that data writing= is not parallelized.

David J.
=C2=A0 --000000000000cebb0106433c5711--