Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes
Дата
Msg-id CAMqTPq=5KVOSKaxry0PFA8wVQWN8WsdycM=FSy1CUPUuGbDv7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
Список pgsql-performance
Дерево обсуждения
> 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 по дате отправления:

Предыдущее
От: Arjun Ranade
Дата:
Сообщение: Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes