Utilizing parallel query execution in Postgresql for SELECT INTO

Question

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

What do you mean by parallel? what's the case? what do you want to achieve? your question is too open, you need to be more specific. — Dan
– Dan, Commented Nov 1, 2017 at 15:10

score 3 · Accepted Answer · 2018-08-15 09:56:25Z

3

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 ...

answered Nov 1, 2017 at 15:10

user330315

Sign up to request clarification or add additional context in comments.

1 Answer 1