CODEWITHSUNDEEP
sqlpostgresqlparallel-processingquery-performance
zlatko
zlatko

Reputation: 650

Utilizing parallel query execution in Postgresql for SELECT INTO

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

Upvotes: 0

Views: 350

Answers (1)

user330315
user330315

Reputation:

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

Upvotes: 3

Related Questions