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

Поиск
Список
Период
Сортировка
От Hou, Zhijie
Тема RE: Parallel INSERT (INTO ... SELECT ...)
Дата
Msg-id 8f4ec40e02e1427ab584e9acdc4336b4@G08CNEXMBPEKD05.g08.fujitsu.local
обсуждение исходный текст
Ответ на Re: Parallel INSERT (INTO ... SELECT ...)  (Greg Nancarrow <gregn4422@gmail.com>)
Ответы Re: Parallel INSERT (INTO ... SELECT ...)  (Greg Nancarrow <gregn4422@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Greg Nancarrow
Дата:
Сообщение: Re: Parallel INSERT (INTO ... SELECT ...)
Следующее
От: Greg Nancarrow
Дата:
Сообщение: Re: Parallel INSERT (INTO ... SELECT ...)