在PostgreSQL中将并行查询执行用于SELECT INTO [英] Utilizing parallel query execution in Postgresql for SELECT INTO

问题描述

SELECT INTO查询是否支持Postgresql中的并行查询执行?

Is parallel query execution in Postgresql supported for SELECT INTO queries?

推荐答案

否.并行执行不适用于DDL语句-仅适用于只读查询.

No. Parallel execution is not available for DDL statements - only for read only queries.

不推荐使用的SELECT .. INTO ...创建一个新表，因此它具有DDL资格.

The deprecated SELECT .. INTO ... creates a new table and thus it qualifies as DDL.

还建议改用CREATE TABLE .. AS SELECT ....

更新:Postgres 11(将于2018年底发布)将支持CREATE TABLE ... AS SELECT ...

Update: Postgres 11 (to be released end of 2018) will support parallel query execution for CREATE TABLE ... AS SELECT ...

这篇关于在PostgreSQL中将并行查询执行用于SELECT INTO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！