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

From: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Greg Nancarrow <gregn4422(at)gmail(dot)com>, PostgreSQL Hackers <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" <tsunakawa(dot)takay(at)fujitsu(dot)com>, "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>
Subject: RE: Parallel INSERT (INTO ... SELECT ...)
Date: 2021-03-18 03:34:34
Message-ID: OS0PR01MB5716D894437A7136661166AB94699@OS0PR01MB5716.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > If a table parameter value is set and the
> > equivalent <literal>toast.</literal> parameter is not, the TOAST table
> > 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_insert_enabled</literal>,
> > + are not supported on partitioned tables, but may be specified for
> > + individual leaf partitions.
> > </para>
> >
>
> Your patch looks good to me. While checking this, I notice a typo in the
> previous patch:
> - planner parameter <varname>parallel_workers</varname>.
> + planner parameter <varname>parallel_workers</varname> and
> + <varname>parallel_insert_enabled</varname>.
>
> Here, it should be /planner parameter/planner parameters.

Thanks amit and justin for pointing this out !
The changes looks good to me.

Best regards,
houzj

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message tsunakawa.takay@fujitsu.com 2021-03-18 03:38:09 RE: libpq debug log
Previous Message Amit Kapila 2021-03-18 03:28:14 Re: Parallel INSERT (INTO ... SELECT ...)