Re: Parallel INSERT (INTO ... SELECT ...)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Greg Nancarrow <gregn4422(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, vignesh C <vignesh21(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, tsunakawa(dot)takay(at)fujitsu(dot)com, tanghy(dot)fnst(at)fujitsu(dot)com
Subject: Re: Parallel INSERT (INTO ... SELECT ...)
Date: 2021-03-18 02:52:28
Message-ID: 20210318025228.GE11765@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 12, 2021 at 04:05:09PM +0900, Amit Langote wrote:
> On Fri, Mar 12, 2021 at 6:10 AM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> > Note also this CF entry
> > https://commitfest.postgresql.org/32/2987/
> > | Allow setting parallel_workers on partitioned tables

I'm rebasing that other patch on top of master (with this patch), and I noticed
that it adds this bit, and this patch should have done something similar:

--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1340,4 +1340,5 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
will use the table's parameter value.
- Specifying these parameters for partitioned tables is not supported,
- but you may specify them for individual leaf partitions.
+ These parameters, with the exception of <literal>parallel_workers</literal>,
+ are not supported on partitioned tables, but you may specify them for
+ individual leaf partitions.
</para>

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2021-03-18 02:55:11 Re: New IndexAM API controlling index vacuum strategies
Previous Message Tom Lane 2021-03-18 02:33:59 Re: Getting better results from valgrind leak tracking