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?
|
Список | 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 по дате отправления: