RE: Parallel INSERT (INTO ... SELECT ...) - Mailing list pgsql-hackers

From Hou, Zhijie
Subject RE: Parallel INSERT (INTO ... SELECT ...)
Date
Msg-id 8f4ec40e02e1427ab584e9acdc4336b4@G08CNEXMBPEKD05.g08.fujitsu.local
Whole thread Raw
In response to Re: Parallel INSERT (INTO ... SELECT ...)  (Greg Nancarrow <gregn4422@gmail.com>)
Responses Re: Parallel INSERT (INTO ... SELECT ...)  (Greg Nancarrow <gregn4422@gmail.com>)
List pgsql-hackers
> Posting an updated set of patches.

A minor comment about doc.

+  <para>
+    Where the above target table features are determined to be, at worst,
+    parallel-restricted, rather than parallel-unsafe, at least a parallel table
+    scan may be used in the query plan for the <literal>INSERT</literal>
+    statement. For more information about Parallel Safety, see
+    <xref linkend="parallel-safety"/>.
+  </para>

It seems does not mention that if target table is a foreign/temp table, a parallel table scan may be used.

So how about:

+  <para>
+    Where the target table is a foreign/temporary table or the above target table features
+    are determined to be, at worst, parallel-restricted, rather than parallel-unsafe,
+    at least a parallel table scan may be used in the query plan for the
+    <literal>INSERT</literal> statement. For more information about Parallel Safety,
+    see <xref linkend="parallel-safety"/>.
+  </para>

Best regards,
houzj



pgsql-hackers by date:

Previous
From: Greg Nancarrow
Date:
Subject: Re: Parallel INSERT (INTO ... SELECT ...)
Next
From: Greg Nancarrow
Date:
Subject: Re: Parallel INSERT (INTO ... SELECT ...)