Postgres Pro
Downloads
Home   >   mailing lists

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

From Vladimir Ryabtsev
Subject Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes
Date
Msg-id CAMqTPq=5KVOSKaxry0PFA8wVQWN8WsdycM=FSy1CUPUuGbDv7w@mail.gmail.com
Whole thread Raw
In response to Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
List pgsql-performance
Tree view
> 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"?

Vlad

pgsql-performance by date:

Previous
From: Arjun Ranade
Date:
Subject: Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes
Next
From: Tom Lane
Date:
Subject: Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes