Is parallel query execution in Postgresql supported for SELECT INTO queries?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
No. Parallel execution is not available for DDL statements - only for read only queries.
The deprecated SELECT .. INTO ... creates a new table and thus it qualifies as DDL.
It is also recommended to use CREATE TABLE .. AS SELECT ... instead.
Update: Postgres 11 (to be released end of 2018) will support parallel query execution for CREATE TABLE ... AS SELECT ...
