CREATE TABLE with parallel workers, 10.0?

From: Joshua Chamberlain <josh(at)zephyri(dot)co>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CREATE TABLE with parallel workers, 10.0?
Date: 2017-02-15 05:24:47
Message-ID: CAFBoRzeoDdjbPV4riCE+2ApV+Y8nV4HDepYUGftm5SuKWna3rQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

(I'm posting to hackers since I got no response on the general list.)

I use Postgres + PostGIS quite heavily, and recently have been taking full
advantage of the new parallelism in 9.6. I'm now running queries in a few
hours that would otherwise take more than a day.

However, parallelism is disabled for all queries that perform writes (as
documented). I would normally run "CREATE TABLE AS [some super-expensive
query]", but since that can't use parallelism I'm using the \o option in
psql, creating the table separately, and then \copy-ing in the results.
That works, but "CREATE TABLE AS" would be more convenient.

Are there plans in 10.0 to allow parallelism in queries that write, or at
least in "CREATE TABLE AS" queries? (Support in materialized views would be
great, too!)

Thanks,
Joshua Chamberlain

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-02-15 05:30:13 Re: CREATE TABLE with parallel workers, 10.0?
Previous Message Andres Freund 2017-02-15 05:17:59 Re: bytea_output vs make installcheck