Re: INSERT INTO SELECT, Why Parallelism is not selected?

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: INSERT INTO SELECT, Why Parallelism is not selected?
Дата
Msg-id CAA4eK1L1ZOve4J_TK+HG3-VcG+vYsM=kryCKk5HiM+8Wsrdhqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: INSERT INTO SELECT, Why Parallelism is not selected?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: INSERT INTO SELECT, Why Parallelism is not selected?  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Wed, Jul 15, 2020 at 12:32 AM Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Sat, Jul 11, 2020 at 8:37 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:
> > I have just notice that the parallelism is off even for the select
> > part of the query mentioned in the $subject.  I see the only reason it
> > is not getting parallel because we block the parallelism if the query
> > type is not SELECT.  I don't see any reason for not selecting the
> > parallelism for this query.
>
> There's a relevant comment near the top of heap_prepare_insert().
>

I think that is no longer true after commits 85f6b49c2c and 3ba59ccc89
where we have allowed relation extension and page locks to conflict
among group members.  We have accordingly changed comments at a few
places but forgot to update this one.  I will check and see if any
other similar comments are there which needs to be updated.

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: WIP: BRIN multi-range indexes
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: replication_origin and replication_origin_lsn usage on subscriber