Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes - Mailing list pgsql-performance

From Tom Lane
Subject Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
Date
Msg-id 22616.1538080889@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes  (Vladimir Ryabtsev <greatvovan@gmail.com>)
Responses Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes  (Vladimir Ryabtsev <greatvovan@gmail.com>)
List pgsql-performance
Tree view 
Vladimir Ryabtsev <greatvovan@gmail.com> writes:
>> The reason for the plan shape difference is probably that the bare SELECT
>> is allowed to use parallelism while INSERT/SELECT isn't.

> In case parallelism is used, should it report in the plan as something like
> "workers planned: N"?

It did --- see the Gather node.

            regards, tom lane

pgsql-performance by date:

Previous
From: Vladimir Ryabtsev
Date:
Subject: Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes
Next
From: Vladimir Ryabtsev
Date:
Subject: Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes